Data need alternate wise.

[sksanjeev786]

Hi Team

I need data alternate-wise..

in Each excel cell.
Below is the example

GT

GT_20

PBKS

PBKS_17

LSG

LSG_12

Book1
	A	B
1	GT	GT_20
2	PBKS	PBKS_17
3	LSG	LSG_12
4	RR	RR_3
5	RCB	RCB_1
6	CSK	CSK_12
7	GT	GT_9
Sheet1

 

[Georgiboy]

Potential Excel 365 option?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	GT	GT_20		GT	GT_20	PBKS	PBKS_17	LSG	LSG_12	RR	RR_3	RCB	RCB_1	CSK	CSK_12	GT	GT_9
2	PBKS	PBKS_17
3	LSG	LSG_12
4	RR	RR_3
5	RCB	RCB_1
6	CSK	CSK_12
7	GT	GT_9
Sheet1

Cell Formulas
Range	Formula
D1:Q1	D1	=TOROW(A1:B7)
Dynamic array formulas.

 

[sksanjeev786]

Potential Excel 365 option?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	GT	GT_20		GT	GT_20	PBKS	PBKS_17	LSG	LSG_12	RR	RR_3	RCB	RCB_1	CSK	CSK_12	GT	GT_9
2	PBKS	PBKS_17
3	LSG	LSG_12
4	RR	RR_3
5	RCB	RCB_1
6	CSK	CSK_12
7	GT	GT_9
Sheet1

Cell Formulas
Range	Formula
D1:Q1	D1	=TOROW(A1:B7)
Dynamic array formulas.

Thank you so much!!!!