Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Rows for each column

brent_excel
5 - Atom

Hello - 

 

I'm wondering if someone knows how to take the take this input to create the following output:


Basically for each date in the columns, I would like to show the price, item and units

 

input           
            
PriceItem7/10/20217/17/20217/24/20217/31/2021      
$15.99ITEM F69  3      
$15.99ITEM G3954 99      
$17.99ITEM F 5        
$18.99ITEM E 33 40      
$19.99ITEM A59976040      
$19.99ITEM B52  46      
$21.99ITEM B 40 55      
$21.99ITEM C  131      
$21.99ITEM D          
$32.99ITEM A  8816      
$49.99ITEM H          
            
            
            
output           
            
7/10/20217/10/20217/10/20217/17/20217/17/20217/17/20217/24/20217/24/20217/24/20217/31/20217/31/20217/31/2021
PriceItemUnitsPriceItemUnitsPriceItemUnitsPriceItemUnits
$15.99ITEM F69$15.99ITEM G54$19.99ITEM A60$15.99ITEM F3
$15.99ITEM G39$17.99ITEM F5$21.99ITEM C13$18.99ITEM G99
$19.99ITEM A59$18.99ITEM E33$32.99ITEM A88$18.99ITEM E40
$19.99ITEM B52$19.99ITEM A97   $19.99ITEM A40
   $21.99ITEM B40   $19.99ITEM B46
         $21.99ITEM B55
         $21.99ITEM C1
         $32.99ITEM A16
2 REPLIES 2
binu_acs
21 - Polaris

@brent_excel One way of doing this

binuacs_0-1679610579663.png

 

Dina
9 - Comet

Another thought.

 

Dina_2-1679614176296.png

 

Labels
Top Solution Authors