VBA TO RE-ARRANGE DATA

[samuelnjogu]

Hi guys,

I have two sheets RawData and Desired Outcome ( Which I have prepared manually). Kindly help me with a VBA code to re-arrange the raw data to appear as the one in the Desired outcome sheet.

Thanks in Advance...

 

[Foxtrots]

Hi guys,

I have two sheets RawData and Desired Outcome ( Which I have prepared manually). Kindly help me with a VBA code to re-arrange the raw data to appear as the one in the Desired outcome sheet.

Thanks in Advance...

Hi Samuel,

See the attached, if the info in column 2 is typed into a single cell rather than multiple cells in column 2 like you have provided you could then use the sheet named Desired Outcome (2).

Hope this is what you been wanting.

 

[samuelnjogu]

Hi @Foxtrots my goal was not to sort the data but to generate the desired data from the raw data. What this means is that i have included the desired data just to show how i want the outcome to look like.