Columns to rows

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
 
B

Bernard Liengme

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
 
D

duane

it sounds like you want to copy the first line of all of the 8 lin
groups into one column. is that correct
 
Top