COLUMN 1 to become column names and COLUMN 2 to become the data

[kathbanc]

Good Day! 

Hopefully you can help me on this. 

INPUT 

OUPUT

[ShankerV]

Hi @kathbanc 

One way of doing this.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @kathbanc 

Step 1: Input data

Step 2:

Many thanks

Shanker V

[kathbanc]

thank you @ShankerV as always