How to structure data in a horizontal table

AgiGovind

Hello,

I have a requirement of arranging data in multi horizontal table. Any advice on how to achieve this is greatly appreciated.

Below sample, i am trying to compare the client payment date and amount with my system details.

Input 1 

Pay Date	Client		Client		Client		Client		Client
	AAA		BBB		CCC		DDD		EEE
11/1/2024
11/2/2024
11/3/2024
11/4/2024	$600
11/5/2024
11/6/2024			$700
11/7/2024
11/8/2024					$900
11/9/2024
11/10/2024							$550
11/11/2024
11/12/2024									$250
11/13/2024
11/14/2024
11/15/2024

Input 2 

Pay Date	My System	Payment
11/4/2024	AAA#	$600
11/6/2024	BBB#	$700
11/9/2024	CCC#	$900
11/10/2024	DDD#	$550
11/13/2024	EEE#	$250

Output:

Pay Date	Client	My System	Client	My System	Client	My System	Client	My System	Client	My System
	AAA	AAA#	BBB	BBB#	CCC	CCC#	DDD	DDD#	EEE	EEE#
11/1/2024
11/2/2024
11/3/2024
11/4/2024	$600	$600
11/5/2024
11/6/2024			$700	$700
11/7/2024
11/8/2024					$900
11/9/2024						$900
11/10/2024							$550	$550
11/11/2024
11/12/2024									$250
11/13/2024										$250
11/14/2024
11/15/2024

Qiu

@AgiGovind 
Manipulating non-structure data to non-structured data is not really the strong point of Alteryx.
but anyway, maybe we can something as below.

118-Agi007.yxmd