Alteryx Designer Desktop Discussions

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

Need help transforming table data into better format

D_Y
8 - Asteroid

Hi everyone

 

I have data that currently looks like this

 

 Product A   
  January 2024February 2024March 2024
nullRevenue101112
nullCost123
nullProfit999
     
 LOCAL   
 INVESTMENT   
 Product B   
null 

00:00:00:00

00:00:00:0000:00:00:00
nullRevenue202122
 Cost1098
 Profit101214
     
 Product C   
  

00:00:00:00

00:00:00:0000:00:00:00
nullRevenue 3031 32 
nullCost 151413 
 Profit 151719 

 

I'm trying to get it into a more tabular/database format:

ProductRevenueCostProfitDate
Product A1019January 2024
Product B201010January 2024
Product C301515January 2024
Product A...11....2....9....February 2024...
...and so on    

 

You can ignore/omit the other text/strings/words like "null"s, "LOCAL","INVESTMENT", and 00:00:00.

 

Thanks for any help! 

3 REPLIES 3
Bren_Spill
11 - Bolide

Hi @D_Y - see workflow attached. 

Bren_Spill
11 - Bolide

@D_Y - update to fix date order

D_Y
8 - Asteroid

Thank you @Bren_Spill !

Labels