sorting data into a table by one column and one row

[Zande409]

Hello, I'm trying to turn the raw data attached into a sorted format where the job number is the first column and the work description is the first row (see attached). How is a table like the 2nd picture made? This may be a simple question but I could not find the answer. Any help would be much appreciated.

 

[DanteAmor]

Welcome to the MrExcel Message Board!

None of the data in the left image matches the data in the right image.
But I think that with the pivot table it can help you.
You can find videos on how to create a pivot table.

Dante Amor
	A	B	C	D	E	F	G
1	Job Number	Work	Hours		Sum
2	1537039	Cab Cirus	100.53		Job	Cab Cirus	Cab Switch
3	1537101	Cab Switch	83.90		1537039	100.53
4	1537045	Cab Cirus	83.56		1537045	83.56
5	1537046	Cab Cirus	82.33		1537046	82.33
6	1537088	Cab Switch	79.17		1537088		79.17
7					1537101		83.9
Hoja8