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

"TEB2" wrote in message
...
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