Using Excel data for report headings
 

I have created a list in a spreadsheet with projects listed in rows and
various details relating to the project in the other columns. One of these
details is " Current Project Stage". My challenge is to create a summary
table in another sheet that shows my 5 Project stages in columns and then
corresponding project names listed in rows. This way I have a nice visual
report of what is in stage 1, what is in stage 2, etc...

The trick is getting the project names listed. Through Pivot, I could only
get sum, count, etc. per stage. Any help would be great!