Rearrange data into two columns

[gmcgough600]

Looking for some advice, is there a way (without macros) to rearrange data that has been split in the way shown below (like two columns of data but split across 2n columns, n being >1):

A	1.00	E	5.00
B	2.00		H	8.00
C	3.00	F	6.00
D	4.00	G	7.00

Hoping to convert to this (not gaps removed if possible):

A	1
B	2
C	3
D	4
E	5
F	6
G	7
H	8

I need this to be done using a formula or a combination of multiple formulae.

Thanks in advance

 

[hagia_sofia]

Hello, what version of Excel are you using?

 

[Joe4]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Fluff]

If you have 365, how about

Fluff.xlsm
	A	B	C	D	E
1	A	1	E	5
2	B	2		H	8
3	C	3	F	6
4	D	4	G	7
5
6	A	1
7	B	2
8	C	3
9	D	4
10	E	5
11	F	6
12	G	7
13	H	8
Main

Cell Formulas
Range	Formula
A6:B13	A6	=SORT(WRAPROWS(TOCOL(A1:E4,1),2))
Dynamic array formulas.