View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] anasab@gmail.com is offline
external usenet poster
 
Posts: 2
Default Combine multiple columns into two long columns, Repeating rows in first column


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