Creating Table with Multiple Value Columns

Hello Alteryx Community,

I am seeking your assistance in creating a table that takes specific columns into account. The desired output should resemble the following format and be exported to an Excel file.

Table Output.PNG

I have attached the data excel for your reference.

Looking forward for your response.

Kamen

Data for Table.xlsx

Workflow

Transformation

Accepted answers

aatalai

@KamenRider take a look at this, might need some manually adjustments

Creating Table with Multiple Value Columns.yxzp

All comments

aatalai

@KamenRider not an exact replica of what you asked for but a starting point, if you want the multiple columns heading tehn you will need to look at the reporting tools, hope this helps?

davidskaife

Hi @KamenRider

To generate something like this in Excel you'll need to use the Reporting tools as @aatalai has mentioned - have a look through this three part guide that will be super useful for you, covering merging columns/rows etc and exporting to Excel https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-1/ba-p/974692

KamenRider

Thanks @davidskaife . @aatalai . I have checked the site and seems beyond my knowledge. My challenge includes moving the date as well as the New and Total as column. Can you help me with this?