Cross Tab / Transpose Question

[Mike_at_CG]

Hi Alteryx Community

Is there a way for Alteryx to stack the below columns next to each other by "store" column.

Raw data below

Store	Cash	Statement Date
Wawa	$1,000.00	3/21/2024
Wawa	$2,000.00	3/22/2024
Sheetz	$1,000.00	3/21/2024
Sheetz	$2,000.00	3/22/2024
Royal	$1,000.00	3/21/2024
Royal	$2,000.00	3/22/2024

Hoping to get something to look like the below in order to perform some further calculations.

Store	Cash	Statement Date	Store	Cash	Statement Date
Wawa	$1,000.00	3/21/2024	Wawa	$2,000.00	3/22/2024
Sheetz	$1,000.00	3/21/2024	Sheetz	$2,000.00	3/22/2024
Royal	$1,000.00	3/21/2024	Royal	$2,000.00	3/22/2024

Thank you for your time

[aatalai · Accepted solution]

@Mike_at_CG this should work, however that is based on you only having 2 rows per store, you might need a more complicated extension if there are more. hope it helps

[peterr_h]

As with the above, for 2 rows per store, this is a fairly simple solution.

If not, you'll need to create some form of macro (iterative/batch) which does a similar thing in a more dynamic manner!