Hello,
Can anyone help me with this below ?
I have the data in Row and column format as shown in below,
Column 1 Column 2
Row 1 Apple 1
Row 2 Banana
Row 3 Orange
Row 3 Strawberry
Row 4 Pineapple
Row 5 Apple 2
Row 6 Banana
Row 7 Orange
Row 8 Strawberry
Row 9 Pineapple
Now I want to have the output as below,
Column 1 Column 2
Row 1 Apple 1
Row 2 Banana Apple 1
Row 3 Orange Apple 1
Row 3 Strawberry Apple 1
Row 4 Pineapple Apple 1
Row 5 Apple 2
Row 6 Banana Apple 2
Row 7 Orange Apple 2
Row 8 Strawberry Apple 2
Row 9 Pineapple Apple 2
Would be really appreciated if someone can help me in figuring this out
Solved! Go to Solution.
@binuacs - Thanks, this works perfect.