We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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
binuacs
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