Convert list to rows and columns

[vwang]

Hi,

I currently have a table with the first row as the header and the rest as values. I want to convert it into a table that summarizes the values with column and row descriptors.

Basically I want to get convert this:

to this:

Any thoughts?

Thanks!

Vivian

[Joe_Mako · Accepted solution]

The attached is built with the assumption that you know the field names you want in the end, and have a specific order for the fields.

The attached transposes all data fields, sums the value, appends in known fields, filters to known field matches, splits out Category, cross tab with field order, and renames.

If you had some other dimension you would like to include in your aggregation granularity, you would add it as a Key or Group By to the three orange Transform tools.

[vwang]

This is exactly what I wanted to do. Thank you for the quick response!