I am copying just 4 columns out of 35 columns to show how my data look like.
ID_No ID_Char Target RT
1226465 N8KC N1 34.504
1226465 N8KC N2 35.905
1226466 N8KC N1 29.361
1226466 N8KC N2 29.634
1226467 N8KC N1 32.548
1226467 N8KC N2 31.405
Is it possible to transpose like below..
ID_No ID_Char N1 N2
1226465 N8KC 34.504 35.905
1226466 N8KC 29.361 29.634
1226467 N8KC 32.548 31.405
Looks very simple for 3 to 6 records but with 1000 records and 35 columns is not simple.
This can be easily done in access but checking to see if this is possible in Excel to avoid import and export.
Please suggest and give me some code snippets to play around with VBA code or Formulas based solution.
Thank you
Bookmarks