Transpose/Cross Tab Excel Data

[scmclaug]

New to Alteryx  thanks in advance for any ideas here -- Looking for help importing/converting a formatted excel table (100s of columns of sales data with dynamic number of sales reps by product and project) to more of a flat alteryx file (like on the right) but cant seem to get it to work with transpose cross tab ... header data also merged cells so creating nulls over the quantiy column which I think creating issues --  any ideas?

[jgo · Accepted solution]

Hi @scmclaug,

I recently answer another post similar to this a while ago.

https://community.alteryx.com/t5/Data-Preparation-Blending/How-to-programatically-delete-date-fields...

Your data table is a bit different, however, the approach I used can be applied with some modifications.

[scmclaug]

@jgo

Thanks a ton -- very helpful to see the sequencing of tools you used -- I was able to tailor it just a bit to make it work.   Really appreciate the help --

Steve