Cross Tab / Transpose Question

Question

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 DateWawa $1,000.003/21/2024Wawa $2,000.003/22/2024Sheetz $1,000.003/21/2024Sheetz $2,000.003/22/2024Royal $1,000.003/21/2024Royal $2,000.003/22/2024

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

Store Cash Statement DateStore Cash Statement DateWawa $1,000.003/21/2024Wawa $2,000.003/22/2024Sheetz $1,000.003/21/2024Sheetz $2,000.003/22/2024Royal $1,000.003/21/2024Royal $2,000.003/22/2024

Thank you for your time

aatalai · Accepted Answer

@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