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