vlookup then copy and transpose paste a specific range of cells

[MattTrust]

At a new job with very poor data I need to sort and I'm stock. Trying to ref. a job number, then have it look down a list of the operations, stop at the empty cell and copy and transpose paste it.

Does that make sense?

 

[Kerryx]

power query method

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
2		Column1	Column2			Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9	Column10	Column11	Column12	Column13	Column14
3		92657	B&WCA			92657	0	0	0	0	0	0	0	0	0	0	0	0	0
4		0	JOB			B&WCA	JOB	SAW2	INSHOLD	INSHOLD	SAW2	INSHOLD	ULTRA	INSPECT	INSFINAL	INSHOLD	SHIPPING	CERTS	CMTR
5		0	SAW2
6		0	INSHOLD
7		0	INSHOLD
8		0	SAW2
9		0	INSHOLD
10		0	ULTRA
11		0	INSPECT
12		0	INSFINAL
13		0	INSHOLD
14		0	SHIPPING
15		0	CERTS
16		0	CMTR
Sheet1

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}, {"Column2", type text}}),
    #"Transposed Table" = Table.Transpose(#"Changed Type")
in
    #"Transposed Table"

 

[Kerryx]

or just copy and paste special --- Transpose

 

[MattTrust]

power query method

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
2		Column1	Column2			Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9	Column10	Column11	Column12	Column13	Column14
3		92657	B&WCA			92657	0	0	0	0	0	0	0	0	0	0	0	0	0
4		0	JOB			B&WCA	JOB	SAW2	INSHOLD	INSHOLD	SAW2	INSHOLD	ULTRA	INSPECT	INSFINAL	INSHOLD	SHIPPING	CERTS	CMTR
5		0	SAW2
6		0	INSHOLD
7		0	INSHOLD
8		0	SAW2
9		0	INSHOLD
10		0	ULTRA
11		0	INSPECT
12		0	INSFINAL
13		0	INSHOLD
14		0	SHIPPING
15		0	CERTS
16		0	CMTR
Sheet1

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}, {"Column2", type text}}),
    #"Transposed Table" = Table.Transpose(#"Changed Type")
in
    #"Transposed Table"

This worked out, thank you.