Columns to rows

  • Thread starter Thread starter MileHigh
  • Start date Start date
M

MileHigh

I need to take information from a column and put it in a row. Th
column for each customer is 8 lines and then repeats itself. I need t
know how to get like the information from all line 1's into the sam
column
 
Not sure I see the scenario exactly but look into
(A) Copy followed by Edit|Paste Special->Transpose, OR
(B) the TRANSPOSE function

Come back for needed details
 
it sounds like you want to copy the first line of all of the 8 lin
groups into one column. is that correct
 
Back
Top