Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the below table as data in excel:
TABLE1:
Store Name | Store I | Store II | Store III | ||||
ProductNo | ProductName | Sale | Profit | Sale | Profit | Sale | Profit |
1 | ABC | 1,000 | 200 | 2,000 | 400 | 4,000 | 800 |
2 | XYZ | 4,000 | 800 | 1,000 | 200 | 2,000 | 400 |
Required is
RESULT:
ProductNo | ProductName | Store Name | Sale | Profit |
1 | ABC | Store I | 1,000 | 200 |
2 | XYZ | Store I | 4,000 | 800 |
1 | ABC | Store II | 2,000 | 400 |
2 | XYZ | Store II | 1,000 | 200 |
1 | ABC | Store III | 4,000 | 800 |
2 | XYZ | Store III | 2,000 | 400 |
Have a nice weekend!
Thanks and BR,
SAK
I am using PE. Can you please post the script here?
in the attachment