Oganize cells

[sjhc1177]

hello Im looking for help with displaying employee sales by week.

I use a pivot report to grab my emloyee sales by week and then enter to the left hours worked. I need to organize the employees information in a colum style to give the owner.

IE
wk#1 Mr Smith 100.00 4hrs sales per/hr 25.00
..
wk#52 MR Smith 888.00 6hrs sales per hr 148.00

Report needed

MR Smith Sales per/hr 25.00 ... 148.00


Thanks
Steven