How do you input multiples files but want a company code identifier for each column?

This is what I want:

State Apportionment.png

This is what I have now:

State Apportionment- Alteryx Output.PNG

Input

Accepted answers

We can get you close - the headers and sub headers may not be easily possible though. I would do a Transpose on the data, form your new headers, and Crosstab it back! Here is a start you can work with:

How do you input multiples files but want a company code identifier for each column.yxmd

All comments

We can get you close - the headers and sub headers may not be easily possible though. I would do a Transpose on the data, form your new headers, and Crosstab it back! Here is a start you can work with:

How do you input multiples files but want a company code identifier for each column.yxmd

Quick Links

Tags

This months top contributors

Hollingsworth 335