Alteryx: How to copy and paste data in 3rd and 4th columns

[Anjankumar2021]

i have input data as per below

Series No.	Model No.
12546	BA05
78965	DC78
11223	KA03
55889	SD14
75364	AB11
77889	HKL7
44556	PP22
11223	SDF5
14725	LL05
8855	AW08

Required output:

Total rows need to be divide by 2 ( total rows = 10, each column will have 5 rows of data each) . every time total rows of data will change( may be 100, 180 or 46  rows)

List 1	Model 1	List 2	Model 2
12546	BA05	77889	HKL7
78965	DC78	44556	PP22
11223	KA03	11223	SDF5
55889	SD14	14725	LL05
75364	AB11	8855	AW08

[binuacs · Accepted solution]

@Anjankumar2021 One way of doing this

[usmanbashir]

@Anjankumar2021 - my workflow (attached) is similar to @binuacs , however used Tile tool. Hope this helps!

[flying008]

Hi, @Anjankumar2021 

FYI.

[Anjankumar2021]

@binuacs   if i have 9 records in my input and need 5 records should be in column 1 and 4 records should be in column 2 .....may be if we have total records are odd number llike  99 ( 50in column 1 and 49in column 2) .pls assist

Input:

Series No.	Model No.
12546	BA05
78965	DC78
11223	KA03
55889	SD14
75364	AB11
77889	HKL7
44556	PP22
11223	SDF5
14725	LL05

Output :

                                                                                                                                                                                                  

List 1	Model 1	List 2	Model 2
12546	BA05	77889	HKL7
78965	DC78	44556	PP22
11223	KA03	11223	SDF5
55889	SD14	14725	LL05
75364	AB11

[binuacs · Accepted solution]

@Anjankumar2021 try the attached workflow

[Anjankumar2021]

thank you much for your help!! its working fine