Extracting data from 1 column into 2 columns & Mass Formula copying

[Kexel]

Greetings,
I've recently joined seeking help regarding a Excel related question.

Namely, I am trying to mass copy a formula, but with non-standard copy method.

Sheet1 has data i need to split. (depending on whether the spec. character "|" is on the left or right side) (Pic1.)
On Sheet2 I've made formula that does this. If "|" is on the left then show in column A, if "|" is on the right then show in column B.

Then when I copy it to other columns B,C,D,E..., it skips every other column from Sheet1. (Pic.2.)

I can manually input cell reference A,B,C,D,E... in formulas on Sheet2, but is there any pragmatic way to workaround/do this? Tnx!

Test123.xlsx
	A	B	C
1	2024-01-01	2024-01-02	2024-01-03
2	|A1	|B	|C
3	|A1	|B	|C
4	|A1	|B	|C
5	AAA|	BBB|	CCC|
6	AAA|	BBB|	CCC|
7	AAA|	BBB|	CCC|
Sheet1

Test123.xlsx
	A	B	C	D	E	F	G	H
1	2024-01-01	2024-01-01	2024-01-02	2024-01-02	2024-01-03	2024-01-03	2024-01-04	2024-01-04
2	|A1		|C
3	|A1		|C
4	|A1		|C
5		AAA|		CCC|
6		AAA|		CCC|
7		AAA|		CCC|
Sheet2

Cell Formulas
Range	Formula
C1:H1	C1	=A1+1
A2:A7,C2:C7	A2	=IF(FIND("|",Sheet1!A2)=1,Sheet1!A2,"")
B2:B7,D2:D7	B2	=IF(FIND("|",Sheet1!A2)=4,Sheet1!A2,"")

 

[JamesCanale]

Someone will have a cleaner way...

MrExcelPlayground20.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Sheet 1				Sheet 2
2	1/1/2024	1/2/2024	1/3/2024		1/1/2024	1/1/2024	1/2/2024	1/2/2024	1/3/2024	1/3/2024
3	|A1	|B	|C		|A1		|B		|C
4	|A1	|B	|C		|A1		|B		|C
5	|A1	|B	|C		|A1		|B		|C
6	AAA|	BBB|	CCC|			AAA|		BBB|		CCC|
7	AAA|	BBB|	CCC|			AAA|		BBB|		CCC|
8	AAA|	BBB|	CCC|			AAA|		BBB|		CCC|
Sheet17

Cell Formulas
Range	Formula
G2:J2	G2	=E2+1
E3:J8	E3	=LET(x,$A$3:$C$8,y,E$2,yy,F$2,z,$A$2:$C$2,a,INDEX(x,ROW()-2,XMATCH(y,z,0)),b,IF(LEFT(a,1)="|",a,""),c,IF(RIGHT(a,1)="|",a,""),d,IF(y=yy,b,c),d)