What is the quick way to transfer data from row to column

[Sian1]

Request ID	101	102	104	105	116	134	135	143	147	148	149
R-042A04GC700000											149
R-023A0DAB800000											149
R-042A059Q100000								143			149
R-042A059Q100000
R-042A059Q100000
R-005A0HFX800001		102		105							149
R-042A059Y400000			104			134					149
R-042A059Y400000											149
R-023A0BE0200000											149
R-001A0Y3T700000						134	135
R-001A0Y3T700000					116			143	147		149
R-023A0BE0200000	101

 

[lrobbo314]

Ok, sanity restored. Thought I was having a stroke or something.

 

[MARK858]

Sorry about that, wouldn't want to waste an ambulances time

 

[Sian1]

Sorry about that, wouldn't want to waste an ambulances time

thanks so much for trying. is the KL tab is using VBA instead of Power Query?

 

[Sian1]

one more question, how would i do it if i want to merge all into one page ie Request ID, Code