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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Mailing address block: sorting 1 row to columns 1
lookup and return column number 2
Excel Help to copy information from one row at a time to another sheet 1
Repeating rows dont repeat fully when columns also repeat 4
exchange columns according to some map regarding pairs of numbers 1
moving rows to another sheet 3
insert a line 1

Back
Top