Using Transpose

[Yousifomar]

Hello everyone,

I have data in two columns and I want to turn them from vertical into horizontal, I used transpose but its not giving me what I want here is an example

I have date in rows (Letters below) with data in front of it in the next row (the numbers below) i want to change them to columns with each data and its opposite data in a horizontal way, like below:

A 1
b 2
c 3
A 1 b 2 c 3

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	ID	Paid
2	A	1		A	1	B	2	C	3	D	4	E	5
3	B	2
4	C	3
5	D	4
6	E	5
7
8
Lists

Cell Formulas
Range	Formula
D2:M2	D2	=LET(Rng,A2:B6,r,ROWS(Rng),INDEX(Rng,INT(SEQUENCE(,r*2,,0.5)),MOD(SEQUENCE(,r*2,2),2)+1))
Dynamic array formulas.