Find 2nd Value in a Row, Return Adjacent Cell

[MeditateMan]

Hello, been reading up on the forms and trying different solutions but I am stumped.

I have a row with an NFL Position, and to the right of it the NFL Player's Name. However there are multiple instances of RB and WR.

I need assistance in filling in columns V,X,Y with the 2nd Instance of RB (V), 2nd Instance of WR (X), 3rd Instance of WR (Y) from the same row.

Book2.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1																				QB	RB	RB	WR	WR	WR	TE	Flex	DST
2	QB	Matt Ryan	RB	Najee Harris	RB	Saquon Barkley	FLEX	Justin Jefferson	WR	Brandin Cooks	WR	Michael Pittman	WR	Jahan Dotson	TE	Travis Kelce	DST	Steelers		Matt Ryan	Najee Harris		Brandin Cooks			Travis Kelce	Justin Jefferson	Steelers
3	QB	Jameis Winston	RB	D'Andre Swift	FLEX	Saquon Barkley	RB	Dameon Pierce	WR	Justin Jefferson	WR	Michael Pittman	WR	Christian Kirk	TE	Travis Kelce	DST	Lions		Jameis Winston	D'Andre Swift		Justin Jefferson			Travis Kelce	Saquon Barkley	Lions
4	QB	Trevor Lawrence	RB	Christian McCaffrey	RB	Saquon Barkley	FLEX	Justin Jefferson	WR	Christian Kirk	WR	Marvin Jones	WR	Jahan Dotson	TE	Travis Kelce	DST	Steelers		Trevor Lawrence	Christian McCaffrey		Christian Kirk			Travis Kelce	Justin Jefferson	Steelers
5	QB	Jalen Hurts	RB	Christian McCaffrey	RB	Saquon Barkley	WR	A.J. Brown	WR	Michael Pittman	WR	Jahan Dotson	FLEX	Travis Kelce	TE	Dallas Goedert	DST	Vikings		Jalen Hurts	Christian McCaffrey		A.J. Brown			Dallas Goedert	Travis Kelce	Vikings
6	QB	Carson Wentz	RB	Christian McCaffrey	RB	Saquon Barkley	WR	Terry McLaurin	WR	Michael Pittman	WR	Christian Kirk	FLEX	Jahan Dotson	TE	Travis Kelce	DST	Falcons		Carson Wentz	Christian McCaffrey		Terry McLaurin			Travis Kelce	Jahan Dotson	Falcons
7	QB	Patrick Mahomes	RB	Nick Chubb	RB	Saquon Barkley	WR	DJ Moore	WR	JuJu Smith-Schuster	WR	Christian Kirk	TE	Travis Kelce	FLEX	Zach Ertz	DST	Steelers		Patrick Mahomes	Nick Chubb		DJ Moore			Travis Kelce	Zach Ertz	Steelers
8	QB	Marcus Mariota	RB	Jonathan Taylor	RB	Saquon Barkley	WR	Michael Pittman	WR	Drake London	WR	Jakobi Meyers	FLEX	Travis Kelce	TE	Kyle Pitts	DST	Steelers		Marcus Mariota	Jonathan Taylor		Michael Pittman			Kyle Pitts	Travis Kelce	Steelers
9	QB	Patrick Mahomes	RB	Jonathan Taylor	RB	Saquon Barkley	FLEX	Marquise Brown	WR	JuJu Smith-Schuster	WR	Jahan Dotson	WR	Wan'Dale Robinson	TE	Travis Kelce	DST	Dolphins		Patrick Mahomes	Jonathan Taylor		JuJu Smith-Schuster			Travis Kelce	Marquise Brown	Dolphins
10	QB	Kirk Cousins	RB	Aaron Jones	RB	Saquon Barkley	WR	Davante Adams	WR	Justin Jefferson	FLEX	Adam Thielen	WR	Jahan Dotson	TE	Gerald Everett	DST	Dolphins		Kirk Cousins	Aaron Jones		Davante Adams			Gerald Everett	Adam Thielen	Dolphins
11	QB	Jalen Hurts	RB	Joe Mixon	RB	Aaron Jones	FLEX	Saquon Barkley	WR	Justin Jefferson	WR	Parris Campbell	WR	Romeo Doubs	TE	Travis Kelce	DST	Dolphins		Jalen Hurts	Joe Mixon		Justin Jefferson			Travis Kelce	Saquon Barkley	Dolphins
12	QB	Patrick Mahomes	RB	Joe Mixon	RB	Saquon Barkley	FLEX	Marquise Brown	WR	Michael Pittman	WR	JuJu Smith-Schuster	WR	Randall Cobb	TE	Travis Kelce	DST	Vikings		Patrick Mahomes	Joe Mixon		Michael Pittman			Travis Kelce	Marquise Brown	Vikings
13	QB	Kirk Cousins	RB	Aaron Jones	RB	Saquon Barkley	FLEX	Justin Jefferson	WR	Michael Pittman	WR	Adam Thielen	WR	Jahan Dotson	TE	Travis Kelce	DST	Giants		Kirk Cousins	Aaron Jones		Michael Pittman			Travis Kelce	Justin Jefferson	Giants
Sheet1

Cell Formulas
Range	Formula
T2:T13	T2	=B2
U2:U13	U2	=INDEX(A2:Q2,MATCH("RB",A2:R2,0)+1)
Z2:Z13	Z2	=INDEX(A2:Q2,MATCH("TE",A2:R2,0)+1)
AA2:AA13	AA2	=INDEX(A2:Q2,MATCH("FLEX",A2:R2,0)+1)
AB2:AB13	AB2	=R2
W2:W13	W2	=INDEX(A2:Q2,MATCH("wr",A2:R2,0)+1)

 

[JamesCanale]

MrExcelPlayground11.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
2	QB	Matt Ryan	RB	Najee Harris	RB	Saquon Barkley	FLEX	Justin Jefferson	WR	Brandin Cooks	WR	Michael Pittman	WR	Jahan Dotson	TE	Travis Kelce	DST	Steelers		Matt Ryan	Najee Harris	Saquon Barkley	Brandin Cooks	Michael Pittman	Jahan Dotson	Travis Kelce	Justin Jefferson	Steelers
3	QB	Jameis Winston	RB	D'Andre Swift	FLEX	Saquon Barkley	RB	Dameon Pierce	WR	Justin Jefferson	WR	Michael Pittman	WR	Christian Kirk	TE	Travis Kelce	DST	Lions		Jameis Winston	D'Andre Swift	Dameon Pierce	Justin Jefferson	Michael Pittman	Christian Kirk	Travis Kelce	Saquon Barkley	Lions
4	QB	Trevor Lawrence	RB	Christian McCaffrey	RB	Saquon Barkley	FLEX	Justin Jefferson	WR	Christian Kirk	WR	Marvin Jones	WR	Jahan Dotson	TE	Travis Kelce	DST	Steelers		Trevor Lawrence	Christian McCaffrey	Saquon Barkley	Christian Kirk	Marvin Jones	Jahan Dotson	Travis Kelce	Justin Jefferson	Steelers
5	QB	Jalen Hurts	RB	Christian McCaffrey	RB	Saquon Barkley	WR	A.J. Brown	WR	Michael Pittman	WR	Jahan Dotson	FLEX	Travis Kelce	TE	Dallas Goedert	DST	Vikings		Jalen Hurts	Christian McCaffrey	Saquon Barkley	A.J. Brown	Michael Pittman	Jahan Dotson	Dallas Goedert	Travis Kelce	Vikings
6	QB	Carson Wentz	RB	Christian McCaffrey	RB	Saquon Barkley	WR	Terry McLaurin	WR	Michael Pittman	WR	Christian Kirk	FLEX	Jahan Dotson	TE	Travis Kelce	DST	Falcons		Carson Wentz	Christian McCaffrey	Saquon Barkley	Terry McLaurin	Michael Pittman	Christian Kirk	Travis Kelce	Jahan Dotson	Falcons
7	QB	Patrick Mahomes	RB	Nick Chubb	RB	Saquon Barkley	WR	DJ Moore	WR	JuJu Smith-Schuster	WR	Christian Kirk	TE	Travis Kelce	FLEX	Zach Ertz	DST	Steelers		Patrick Mahomes	Nick Chubb	Saquon Barkley	DJ Moore	JuJu Smith-Schuster	Christian Kirk	Travis Kelce	Zach Ertz	Steelers
8	QB	Marcus Mariota	RB	Jonathan Taylor	RB	Saquon Barkley	WR	Michael Pittman	WR	Drake London	WR	Jakobi Meyers	FLEX	Travis Kelce	TE	Kyle Pitts	DST	Steelers		Marcus Mariota	Jonathan Taylor	Saquon Barkley	Michael Pittman	Drake London	Jakobi Meyers	Kyle Pitts	Travis Kelce	Steelers
9	QB	Patrick Mahomes	RB	Jonathan Taylor	RB	Saquon Barkley	FLEX	Marquise Brown	WR	JuJu Smith-Schuster	WR	Jahan Dotson	WR	Wan'Dale Robinson	TE	Travis Kelce	DST	Dolphins		Patrick Mahomes	Jonathan Taylor	Saquon Barkley	JuJu Smith-Schuster	Jahan Dotson	Wan'Dale Robinson	Travis Kelce	Marquise Brown	Dolphins
10	QB	Kirk Cousins	RB	Aaron Jones	RB	Saquon Barkley	WR	Davante Adams	WR	Justin Jefferson	FLEX	Adam Thielen	WR	Jahan Dotson	TE	Gerald Everett	DST	Dolphins		Kirk Cousins	Aaron Jones	Saquon Barkley	Davante Adams	Justin Jefferson	Jahan Dotson	Gerald Everett	Adam Thielen	Dolphins
11	QB	Jalen Hurts	RB	Joe Mixon	RB	Aaron Jones	FLEX	Saquon Barkley	WR	Justin Jefferson	WR	Parris Campbell	WR	Romeo Doubs	TE	Travis Kelce	DST	Dolphins		Jalen Hurts	Joe Mixon	Aaron Jones	Justin Jefferson	Parris Campbell	Romeo Doubs	Travis Kelce	Saquon Barkley	Dolphins
12	QB	Patrick Mahomes	RB	Joe Mixon	RB	Saquon Barkley	FLEX	Marquise Brown	WR	Michael Pittman	WR	JuJu Smith-Schuster	WR	Randall Cobb	TE	Travis Kelce	DST	Vikings		Patrick Mahomes	Joe Mixon	Saquon Barkley	Michael Pittman	JuJu Smith-Schuster	Randall Cobb	Travis Kelce	Marquise Brown	Vikings
13	QB	Kirk Cousins	RB	Aaron Jones	RB	Saquon Barkley	FLEX	Justin Jefferson	WR	Michael Pittman	WR	Adam Thielen	WR	Jahan Dotson	TE	Travis Kelce	DST	Giants		Kirk Cousins	Aaron Jones	Saquon Barkley	Michael Pittman	Adam Thielen	Jahan Dotson	Travis Kelce	Justin Jefferson	Giants
Sheet29

Cell Formulas
Range	Formula
T2:T13	T2	=B2
U2:U13	U2	=INDEX(FILTER(INDEX(A2:P2,1,SEQUENCE(1,8,2,2)),INDEX(A2:P2,1,SEQUENCE(1,8,1,2))="RB"),1,1)
V2:V13	V2	=INDEX(FILTER(INDEX(A2:P2,1,SEQUENCE(1,8,2,2)),INDEX(A2:P2,1,SEQUENCE(1,8,1,2))="RB"),1,2)
W2:W13	W2	=INDEX(FILTER(INDEX(A2:P2,1,SEQUENCE(1,8,2,2)),INDEX(A2:P2,1,SEQUENCE(1,8,1,2))="WR"),1,1)
X2:X13	X2	=INDEX(FILTER(INDEX(A2:P2,1,SEQUENCE(1,8,2,2)),INDEX(A2:P2,1,SEQUENCE(1,8,1,2))="WR"),1,2)
Y2:Y13	Y2	=INDEX(FILTER(INDEX(A2:P2,1,SEQUENCE(1,8,2,2)),INDEX(A2:P2,1,SEQUENCE(1,8,1,2))="WR"),1,3)
Z2:Z13	Z2	=INDEX(A2:Q2,MATCH("TE",A2:R2,0)+1)
AA2:AA13	AA2	=INDEX(A2:Q2,MATCH("FLEX",A2:R2,0)+1)
AB2:AB13	AB2	=R2

 

[MeditateMan]

Outstanding JamesCanale, I've literally spent 2 hours trying to solve

The actual raw format shows up as below, before my parsing of the file. Could you even provide a solution to save me a step of "cleaning" the original strings?

dk contest Book1.csv
	A	B	C	D	E	F	G	H	I
1	Lineup	QB	RB	RB	WR	WR	WR	TE	Flex
2	QB Matt Ryan RB Najee Harris RB Saquon Barkley FLEX Justin Jefferson WR Brandin Cooks WR Michael Pittman Jr. WR Jahan Dotson TE Travis Kelce DST Steelers
3	QB Jameis Winston RB D'Andre Swift FLEX Saquon Barkley RB Dameon Pierce WR Justin Jefferson WR Michael Pittman Jr. WR Christian Kirk TE Travis Kelce DST Lions
4	QB Trevor Lawrence RB Christian McCaffrey RB Saquon Barkley FLEX Justin Jefferson WR Christian Kirk WR Marvin Jones Jr. WR Jahan Dotson TE Travis Kelce DST Steelers
5	QB Jalen Hurts RB Christian McCaffrey RB Saquon Barkley WR A.J. Brown WR Michael Pittman Jr. WR Jahan Dotson FLEX Travis Kelce TE Dallas Goedert DST Vikings
6	QB Carson Wentz RB Christian McCaffrey RB Saquon Barkley WR Terry McLaurin WR Michael Pittman Jr. WR Christian Kirk FLEX Jahan Dotson TE Travis Kelce DST Falcons
dk contest Book1

 

[Fluff]

Do you have the TEXTSPLIT function yet?

 

[MeditateMan]

Do you have the TEXTSPLIT function yet?

I do not appear to have it yet.

 

[Fluff]

In that case you are probably better off separating the data out for the time being.

 

[JamesCanale]

MrExcelPlayground11.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
19	QB Matt Ryan RB Najee Harris RB Saquon Barkley FLEX Justin Jefferson WR Brandin Cooks WR Michael Pittman Jr. WR Jahan Dotson TE Travis Kelce DST Steelers	QB	Matt Ryan	RB	Najee Harris	RB	Saquon Barkley	FLEX	Justin Jefferson	WR	Brandin Cooks	WR	Michael Pittman Jr.	WR	Jahan Dotson	TE	Travis Kelce	DST	Steelers
20	QB Jameis Winston RB D'Andre Swift FLEX Saquon Barkley RB Dameon Pierce WR Justin Jefferson WR Michael Pittman Jr. WR Christian Kirk TE Travis Kelce DST Lions	QB	Jameis Winston	RB	D'Andre Swift	FLEX	Saquon Barkley	RB	Dameon Pierce	WR	Justin Jefferson	WR	Michael Pittman Jr.	WR	Christian Kirk	TE	Travis Kelce	DST	Lions
21	QB Trevor Lawrence RB Christian McCaffrey RB Saquon Barkley FLEX Justin Jefferson WR Christian Kirk WR Marvin Jones Jr. WR Jahan Dotson TE Travis Kelce DST Steelers	QB	Trevor Lawrence	RB	Christian McCaffrey	RB	Saquon Barkley	FLEX	Justin Jefferson	WR	Christian Kirk	WR	Marvin Jones Jr.	WR	Jahan Dotson	TE	Travis Kelce	DST	Steelers
22	QB Jalen Hurts RB Christian McCaffrey RB Saquon Barkley WR A.J. Brown WR Michael Pittman Jr. WR Jahan Dotson FLEX Travis Kelce TE Dallas Goedert DST Vikings	QB	Jalen Hurts	RB	Christian McCaffrey	RB	Saquon Barkley	WR	A.J. Brown	WR	Michael Pittman Jr.	WR	Jahan Dotson	FLEX	Travis Kelce	TE	Dallas Goedert	DST	Vikings
23	QB Carson Wentz RB Christian McCaffrey RB Saquon Barkley WR Terry McLaurin WR Michael Pittman Jr. WR Christian Kirk FLEX Jahan Dotson TE Travis Kelce DST Falcons	QB	Carson Wentz	RB	Christian McCaffrey	RB	Saquon Barkley	WR	Terry McLaurin	WR	Michael Pittman Jr.	WR	Christian Kirk	FLEX	Jahan Dotson	TE	Travis Kelce	DST	Falcons
Sheet29

Cell Formulas
Range	Formula
B19:S23	B19	=LET(a,(FIND({"QB","RB","WR","TE","FLEX","DST"},A19,SEQUENCE(LEN(A19)))), b,SEQUENCE(ROWS(a)*COLUMNS(a)), c,SORT(UNIQUE(INDEX(a,1+INT((b-1)/COLUMNS(a)),1+MOD(b,COLUMNS(a))))), d,IF(ISERR(INDEX(c,SEQUENCE(ROWS(c)))),LEN(A19),INDEX(c,SEQUENCE(ROWS(c)))), e,INDEX(d,SEQUENCE(ROWS(d)-1,1,1)), f,INDEX(d,SEQUENCE(ROWS(d)-1,1,2)), g,f-e, h,MID(A19,e,g), i,FIND(" ",h), j,LEFT(h,i-1), k,MID(h,i+1,99), l,SEQUENCE(ROWS(h)*2), m,IF(ISODD(l),INDEX(j,INT((l+1)/2)),INDEX(k,INT((l+1)/2))), TRANSPOSE(m))
Dynamic array formulas.

 

[MeditateMan]

MrExcelPlayground11.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
19	QB Matt Ryan RB Najee Harris RB Saquon Barkley FLEX Justin Jefferson WR Brandin Cooks WR Michael Pittman Jr. WR Jahan Dotson TE Travis Kelce DST Steelers	QB	Matt Ryan	RB	Najee Harris	RB	Saquon Barkley	FLEX	Justin Jefferson	WR	Brandin Cooks	WR	Michael Pittman Jr.	WR	Jahan Dotson	TE	Travis Kelce	DST	Steelers
20	QB Jameis Winston RB D'Andre Swift FLEX Saquon Barkley RB Dameon Pierce WR Justin Jefferson WR Michael Pittman Jr. WR Christian Kirk TE Travis Kelce DST Lions	QB	Jameis Winston	RB	D'Andre Swift	FLEX	Saquon Barkley	RB	Dameon Pierce	WR	Justin Jefferson	WR	Michael Pittman Jr.	WR	Christian Kirk	TE	Travis Kelce	DST	Lions
21	QB Trevor Lawrence RB Christian McCaffrey RB Saquon Barkley FLEX Justin Jefferson WR Christian Kirk WR Marvin Jones Jr. WR Jahan Dotson TE Travis Kelce DST Steelers	QB	Trevor Lawrence	RB	Christian McCaffrey	RB	Saquon Barkley	FLEX	Justin Jefferson	WR	Christian Kirk	WR	Marvin Jones Jr.	WR	Jahan Dotson	TE	Travis Kelce	DST	Steelers
22	QB Jalen Hurts RB Christian McCaffrey RB Saquon Barkley WR A.J. Brown WR Michael Pittman Jr. WR Jahan Dotson FLEX Travis Kelce TE Dallas Goedert DST Vikings	QB	Jalen Hurts	RB	Christian McCaffrey	RB	Saquon Barkley	WR	A.J. Brown	WR	Michael Pittman Jr.	WR	Jahan Dotson	FLEX	Travis Kelce	TE	Dallas Goedert	DST	Vikings
23	QB Carson Wentz RB Christian McCaffrey RB Saquon Barkley WR Terry McLaurin WR Michael Pittman Jr. WR Christian Kirk FLEX Jahan Dotson TE Travis Kelce DST Falcons	QB	Carson Wentz	RB	Christian McCaffrey	RB	Saquon Barkley	WR	Terry McLaurin	WR	Michael Pittman Jr.	WR	Christian Kirk	FLEX	Jahan Dotson	TE	Travis Kelce	DST	Falcons
Sheet29

Cell Formulas
Range	Formula
B19:S23	B19	=LET(a,(FIND({"QB","RB","WR","TE","FLEX","DST"},A19,SEQUENCE(LEN(A19)))), b,SEQUENCE(ROWS(a)*COLUMNS(a)), c,SORT(UNIQUE(INDEX(a,1+INT((b-1)/COLUMNS(a)),1+MOD(b,COLUMNS(a))))), d,IF(ISERR(INDEX(c,SEQUENCE(ROWS(c)))),LEN(A19),INDEX(c,SEQUENCE(ROWS(c)))), e,INDEX(d,SEQUENCE(ROWS(d)-1,1,1)), f,INDEX(d,SEQUENCE(ROWS(d)-1,1,2)), g,f-e, h,MID(A19,e,g), i,FIND(" ",h), j,LEFT(h,i-1), k,MID(h,i+1,99), l,SEQUENCE(ROWS(h)*2), m,IF(ISODD(l),INDEX(j,INT((l+1)/2)),INDEX(k,INT((l+1)/2))), TRANSPOSE(m))
Dynamic array formulas.

Thank you thank you!!!!!!!!

 

[MeditateMan]

Do you have the TEXTSPLIT function yet?

Ok, I have acquired textsplit - is there a better/different way?

 

[MeditateMan]

MrExcelPlayground11.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
19	QB Matt Ryan RB Najee Harris RB Saquon Barkley FLEX Justin Jefferson WR Brandin Cooks WR Michael Pittman Jr. WR Jahan Dotson TE Travis Kelce DST Steelers	QB	Matt Ryan	RB	Najee Harris	RB	Saquon Barkley	FLEX	Justin Jefferson	WR	Brandin Cooks	WR	Michael Pittman Jr.	WR	Jahan Dotson	TE	Travis Kelce	DST	Steelers
20	QB Jameis Winston RB D'Andre Swift FLEX Saquon Barkley RB Dameon Pierce WR Justin Jefferson WR Michael Pittman Jr. WR Christian Kirk TE Travis Kelce DST Lions	QB	Jameis Winston	RB	D'Andre Swift	FLEX	Saquon Barkley	RB	Dameon Pierce	WR	Justin Jefferson	WR	Michael Pittman Jr.	WR	Christian Kirk	TE	Travis Kelce	DST	Lions
21	QB Trevor Lawrence RB Christian McCaffrey RB Saquon Barkley FLEX Justin Jefferson WR Christian Kirk WR Marvin Jones Jr. WR Jahan Dotson TE Travis Kelce DST Steelers	QB	Trevor Lawrence	RB	Christian McCaffrey	RB	Saquon Barkley	FLEX	Justin Jefferson	WR	Christian Kirk	WR	Marvin Jones Jr.	WR	Jahan Dotson	TE	Travis Kelce	DST	Steelers
22	QB Jalen Hurts RB Christian McCaffrey RB Saquon Barkley WR A.J. Brown WR Michael Pittman Jr. WR Jahan Dotson FLEX Travis Kelce TE Dallas Goedert DST Vikings	QB	Jalen Hurts	RB	Christian McCaffrey	RB	Saquon Barkley	WR	A.J. Brown	WR	Michael Pittman Jr.	WR	Jahan Dotson	FLEX	Travis Kelce	TE	Dallas Goedert	DST	Vikings
23	QB Carson Wentz RB Christian McCaffrey RB Saquon Barkley WR Terry McLaurin WR Michael Pittman Jr. WR Christian Kirk FLEX Jahan Dotson TE Travis Kelce DST Falcons	QB	Carson Wentz	RB	Christian McCaffrey	RB	Saquon Barkley	WR	Terry McLaurin	WR	Michael Pittman Jr.	WR	Christian Kirk	FLEX	Jahan Dotson	TE	Travis Kelce	DST	Falcons
Sheet29

Cell Formulas
Range	Formula
B19:S23	B19	=LET(a,(FIND({"QB","RB","WR","TE","FLEX","DST"},A19,SEQUENCE(LEN(A19)))), b,SEQUENCE(ROWS(a)*COLUMNS(a)), c,SORT(UNIQUE(INDEX(a,1+INT((b-1)/COLUMNS(a)),1+MOD(b,COLUMNS(a))))), d,IF(ISERR(INDEX(c,SEQUENCE(ROWS(c)))),LEN(A19),INDEX(c,SEQUENCE(ROWS(c)))), e,INDEX(d,SEQUENCE(ROWS(d)-1,1,1)), f,INDEX(d,SEQUENCE(ROWS(d)-1,1,2)), g,f-e, h,MID(A19,e,g), i,FIND(" ",h), j,LEFT(h,i-1), k,MID(h,i+1,99), l,SEQUENCE(ROWS(h)*2), m,IF(ISODD(l),INDEX(j,INT((l+1)/2)),INDEX(k,INT((l+1)/2))), TRANSPOSE(m))
Dynamic array formulas.

Ok, I have acquired textsplit - is there a better/different way than what you showed?