Combining Multiple Columns using Formula

Hi all,

I need help with an Excel problem, if possible. I have 6 columns of data (example below): containing numbers, text, numbers, text... Is there a way using formula on a separate sheet to present them as two columns, so with the number columns A, C and E place one under the other and likewise with the text columns.

This is required for a template in a professional working environment, so hence the need for dynamic formula and the aim to eliminate manual work/errors. Any advice would be welcome, even if anyone could confirm that it is simply not possible (and save me trawling the web for solutions!)

Current situation

A B C D E F
2 aaa 10 ddd 8 ggg
3 bbb 1 eee 7 hhh
9 ccc 5 fff 1 iii

Desired result:

A B
2 aaa
3 bbb
9 ccc
10 ddd
1 eee
5 fff
8 ggg
7 hhh
1 iii

I see the formatting on my example didn't carry through an excel sheet is attached displaying what is needed, if possible.

Not to worry, I have now discovered a way to do this.

Hi,

Solution attached - which actually combines 3 columns into one. An issue for some maybe that it doesn't ignore blanks, so if you require dynamic ranges it may not be suitable.

Based on have data in columns: A, B and C, and the merged column in D (formula entered into D2).

IFERROR(INDEX($A$2:$A$6,ROWS(D1:$D$1)),IFERROR(INDEX($B$2:$B$3,ROWS(D1:$D$1)−ROWS($A$2:$A$6)),IFERROR(INDEX($C$2:$C$5,ROWS(D1:$D$1)−ROWS($A$2:$A$6)−ROWS($B$2:$B$3)),"")))