Move data in pivot table from subtotals to columns

[HeyMike]

Hi,

I need to work with large amounts of data to get information from rows to columns. I'm pretty sure its with a pivot table. How do I do this? I was able to move the data to one single column in the pivot table "field settings" then "layout", however I need each item in its own column.

Below is the screen shot:

Thanks!
Mike

 

[HeyMike]

Answered my own question. This can be done by bringing the data into PowerPivot for excel 2010. Create a flattened pivot table. Solved.