Need Help in Row & Columns

[Santosh080]

Hi
I am new to excel. so need some help in converting a row into multiple column.

I have a excel file with one column like this,

AAA​

123​

KI98​

BBB​

435​

FG45​

CCC​

854​

DF34​

and i want the above data in below format,

AAA​	123​	KI98​
BBB​	435​	FG45​
CCC​	854​	DF34​

Please help how can i do this easily.

Thanks
Santosh

 

[J.Ty.]

Hi,

Here is one of the possible solutions:

Book1
	A	B	C	D	E	F	G	H	I
1	AAA	123	KI98	BBB	435	FG45	CCC	854	DF34
2
3	AAA	123	KI98
4	BBB	435	FG45
5	CCC	854	DF34
Sheet1

Cell Formulas
Range	Formula
A3:A5	A3	=INDEX($A$1:$I$1,3*ROWS(E$3:E3)-2)
B3:B5	B3	=INDEX($A$1:$I$1,3*ROWS(F$3:F3)-1)
C3:C5	C3	=INDEX($A$1:$I$1,3*ROWS(G$3:G3))

 

[Santosh080]

thank you very much.

 

[J.Ty.]

Thanks for the feedback and good luck!

J.Ty.