Transposing columns and rows

[Guest]

I have 84 column headings which are work stream projects. In column A is the
project week #. All other columns have employees assigned to that work
stream.

What I want is 3 columns: week_# employee work_stream

 

[JulieD]

Hi

if i'm understanding you correctly, check out John Walkenbach's web site on
"create a database table from a summary table"
http://j-walk.com/ss/excel/usertips/tip068.htm

Cheers
julied