Thread: How do I fit columns A and B to column C with A on top of B?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
vezerid vezerid is offline
external usenet poster
  
Posts: 751
Default How do I fit columns A and B to column C with A on top of B?
Say you want to start your serialized data in cell AA2. Enter in AA2
the following formula (assuming data in A2:L101):

=INDEX($A$2:$L$101,INT((ROW()-ROW($AA$2))/12),MOD(ROW()-ROW($AA$2),
12))

Copy down.

HTH
Kostis Vezerides

On Jun 27, 5:21 pm, Emma wrote:
I have 12 columns of data that I want go into one column; Column A is first,
then Column B follows underneath, then Column C, etc. using Excel.

Reply With QuoteReply With Quote