Cross-tab / Transform to organize data

[calvincarr29]

I need the data is Sheet 1 to look like Sheet 2 in the attached excel file.

[ShankerV]

Hi @calvincarr29 

One way of doing this.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @calvincarr29 

Step 1: 

 

Step 2:

Step 3:

Step 4:

 

Many thanks

Shanker V 

[binuacs · Accepted solution]

@calvincarr29 a batch macro approach