search 2 columns return data in different row

[kermitchell]

Hi - needing some help with a formula - I have several columns taken from sage data. I have in one column employees hours and another employees name, as you can see sometimes employees name appears more than once. what I am needing is in another row is employee name who was working on the job to appear and all their hours beside their name.

I have attached file which hopefully will let you see what I am working on.

Thanks you.

[NBVC]

A simple pivot table should do it.

See attached.

Pivot table created from Data|Pivot Tables....

Click Next,

Select destionation, click Next.

Click Layout, drag Employee to Row label area and Hours to Data area...

Click Finish.