Hi All,
The scenario is as follows:
Sales | Profit | |||||
Product | Retailer 1 | Retailer2 | Retailer 3 | Retailer 1 | Retailer2 | Retailer 3 |
A | 20 | 10 | 15 | 12 | 13 | 14 |
B | 29 | 12 | 43 | 34 | 34 | 54 |
C | 12 | 43 | 53 | 43 | 54 | 24 |
D | 54 | 43 | 12 | 23 | 64 | 78 |
E | 23 | 56 | 44 | 13 | 23 | 43 |
The sales and profit needs to be concatenated with the next row.
Product | Sales-Retailer 1 | Sales-Retailer2 | Sales- Retailer 3 | Profit-Retailer 1 | Profit-Retailer2 | Profit- Retailer 3 |
A | 20 | 10 | 15 | 12 | 13 | 14 |
B | 29 | 12 | 43 | 34 | 34 | 54 |
C | 12 | 43 | 53 | 43 | 54 | 24 |
D | 54 | 43 | 12 | 23 | 64 | 78 |
E | 23 | 56 | 44 | 13 | 23 | 43 |
How would this be possible?
Thank you in advance for the solution
Solved! Go to Solution.
Hi Ben!!
The solution looks perfect. Can you please help me implement on the attached data?
Thank you Ben! It worked very well!