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

[MichalM · Accepted solution]

@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

[Spatel68]

Thank you MichalM for a quick and concise response.  I am new to Alteryx and your flow helped me learn some new ways of obtaining the solution.