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

 

[MARK858]

If you mean the data labelled Sample is your starting range then I get

Book7
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Request ID	101	102	104	105	116	134	135	143	147	148	149		Request ID	Code
2	R-042A04GC700000											149		R-042A04GC700000	149
3	R-023A0DAB800000											149		R-023A0DAB800000	149
4	R-042A059Q100000								143			149		R-042A059Q100000	143
5	R-042A059Q100000													R-042A059Q100000	149
Sheet1

 

[Sian1]

If you mean the data labelled Sample is your starting range then I get

Book7
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Request ID	101	102	104	105	116	134	135	143	147	148	149		Request ID	Code
2	R-042A04GC700000											149		R-042A04GC700000	149
3	R-023A0DAB800000											149		R-023A0DAB800000	149
4	R-042A059Q100000								143			149		R-042A059Q100000	143
5	R-042A059Q100000													R-042A059Q100000	149
Sheet1

So what did I do wrong. I copied the same code

 

[MARK858]

I am afraid I don't know. Is it possible to upload your actual file to a free file hosting site like www.box.com (it is free for personal use) or www.dropbox.com, mark it for sharing and post the link it provides in the thread and I will see if I can see anything.
Make sure that you alter any sensitive data in the file.

 

[Sian1]

I am afraid I don't know. Is it possible to upload your actual file to a free file hosting site like www.box.com (it is free for personal use) or www.dropbox.com, mark it for sharing and post the link it provides in the thread and I will see if I can see anything.
Make sure that you alter any sensitive data in the file.

Oh okay will do

 

[Sian1]

Oh okay will do

test.xlsx

Shared with Dropbox

www.dropbox.com

 

[MARK858]

Not exactly the right way of doing it but see if the file in the link is doing what you want (by the way I just changed the colours so I could read them easier, you can change them back).

test (3).xlsx | Powered by Box

app.box.com

 

[pto160]

For this small sample above, is it possible to use a formula to transfer the data from row to column ?

 

[sandy666]

like this?

Request ID	Code.1	Code.2	Code.3	Code.4	Code.5	Code.6	Code.7	Code.8	Code.9	Code.10	Code.11	Code.12	Code.13	Code.14	Code.15	Code.16	Code.17	Code.18	Code.19	Code.20	Code.21	Code.22	Code.23	Code.24	Code.25	Code.26	Code.27	Code.28	Code.29	Code.30	Code.31	Code.32	Code.33	Code.34	Code.35	Code.36	Code.37	Code.38	Code.39	Code.40
R-005A09WJ800000	101	102	104	105	106	107	109	112	114	115	116	117	118	119	120	122	124	126	127	129	130	131	132	133	134	135	136	137	138	139	140	141	142	143	144	145	146	147	148	149

 

[Sian1]

Not exactly the right way of doing it but see if the file in the link is doing what you want (by the way I just changed the colours so I could read them easier, you can change them back).

test (3).xlsx | Powered by Box

app.box.com

that is what i want, however i didn't get the same results, is it because of the code i use?

 

[MARK858]

It is different code inside the query. Copy and paste that and try.