Excel - combine, but not merge, data into a column

Question

I need to combine multiple columns into one long column whilst preserving the order of the values for each column.

The key point here is that the numeric order is preserved (e.g. 1, 2, 3,..., see example below) rather than just combining columns into one long one.

Example:

Column A:
   1
   3       
Column B:
   2
   4    
Output: 
   1
   2
   3
   4

Unfortunately i've not found a macro and I'm not savvy enough with Excel to have yet found a work-around.

Would appreciate any help!

Thanks in advance!

In an empty column: =INDEX(A:B,INT((ROW(1:1)-1)/2)+1,MOD(ROW(1:1)-1,2)+1) in the first row and copy/drag down. — Scott Craner
– Scott Craner, Commented Oct 14, 2016 at 15:39
Possible duplicate: stackoverflow.com/questions/10612386/… — David Zemens
– David Zemens, Commented Oct 14, 2016 at 15:40

Sksi · Accepted Answer · 2016-10-17 10:11:44Z

1

Thanks for the help above! As it turns out Scott's answer worked perfectly. For posterity:

In an empty column: =INDEX(A:B,INT((ROW(1:1)-1)/2)+1,MOD(ROW(1:1)-1,2)+1) in the first row and copy/drag down.

answered Oct 17, 2016 at 10:11

Sksi

134 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Universus · Accepted Answer · 2016-10-14 15:44:08Z

0

Click on your desired output cell press "=" key and then click on input cell. If you have many rows you can use "smart repeating function" by simply clicking in output cell and dragging it down by its right-bottom corner.

answered Oct 14, 2016 at 15:44

Universus

4064 silver badges13 bronze badges

Collectives™ on Stack Overflow

Excel - combine, but not merge, data into a column

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related