Combine multiple columns into two long columns, Repeating rows in first column

Combine multiple columns into two long columns, Repeating rows in first column

Post by anasa » Wed, 02 Aug 2006 01:07:45



I need help combining data in multiple columns into two long columns
with the rows in the first column repeating:

Example

Start

Column1, Column2, column3, Column4, Column5
Joe, 1000, 15000, 300, 20
Mike, 400, 5000, 37, 500
Gary, 90, 3000, 100, 66


End

Column1, Column2
Joe, 1000
Joe, 15000
Joe, 300
Joe, 20
Mike, 400
Mike, 5000
Mike, 37
..................

Thanks
 
 
 

Combine multiple columns into two long columns, Repeating rows in first column

Post by anasa » Wed, 02 Aug 2006 01:08:33


I need help combining data in multiple columns into two long columns
with the rows in the first column repeating:

Example

Start

Column1, Column2, column3, Column4, Column5
Joe, 1000, 15000, 300, 20
Mike, 400, 5000, 37, 500
Gary, 90, 3000, 100, 66


End

Column1, Column2
Joe, 1000
Joe, 15000
Joe, 300
Joe, 20
Mike, 400
Mike, 5000
Mike, 37
..................

Thanks