Sort Rows into Columns

[BRRLL99]

sequence	ID	1	2	FINAL AMOUNT
101	1	1001	100	600
101	1	SAM	45123	600
101	1	4001	500	600
101	1	JAMS	8612345	600
102	1	9001	350	450
102	1	JIM	1234567	450
102	1	7001	100	450
102	1	PHIL	789321	450

Expected output:  each two rows in the input should be sorted into expected output

Sequence	ID	Trans ID	NAME	AMOUNT	NUMBER	Final Amount
101	1	1001	SAM	100	45123	600
101	1	4001	JAMS	500	8612345	600
102	1	9001	JIM	350	1234567	450
102	1	7001	PHIL	100	789321	450

[BRRLL99 · Accepted solution]

Resolved!
using cross tab, transpose, multi row formula tool

If any has different please give it a try

[flying008 · Accepted solution]

Hi, @BRRLL99 

FYI.