Convert crosstab to tabular format using Alteryx

Spatel68

Hi,

I have a formatted report that is feed for another report.  Is there a way to remove nulls and make the report tabular.  Please see the original file (Test 09_2019.xlsx).  I created a workflow to format in the crosstab which happens to be an intermediate step (Test 09_2019.yxmc). Now I want my flow to wrangle the data as shown in Test 09_2019_Output.xlsx (just show one column transposed, but I'll need entire report transposed).

Regards

Snehal

Test 09_2019.xlsx

Test 09_2019_Output.xlsx

Test 09_2019.yxmc

MichalM

@Spatel68 

The attached should work for you

• First I identified what year each of the sections belongs to using the Multi-row Formula
• I then split the data into headers and months using filters, clean it up and bring back together
• I then create a new variable - I call it MONTHYEAR to concatenate the Month and Year together
• In order to be able to sort the data I will create additional column turning the MONTHYEAR into an actual date
• Finally I transpose the data

Hope that makes sense

tabular-format.yxmd