Multiple Column Headers with Table Tool

[ajapczynski]

Hi,

I have a sample data that looks like this:

Life	Paul	John	Betty	Method
3	100	500	1000	Method 1
5	200	600	2000	Method 1
7	1000	700	3000	Method 1
15	150	800	4000	Method 1
39	40000	900	5000	Method 1
3	10	450	900	Method 2
5	30	550	800	Method 2
7	500	650	700	Method 2
15	200	750	600	Method 2
39	30000	950	500	Method 2

And I would like to use the Report Tool to make the end result look like this:

In essence, I need two header rows one for the person's name and then underneath that person's name method 1 amounts and method 2 amounts. I have attached the sample data and desired output. 

Any help would be much appreciated!

[fmvizcaino · Accepted solution]

Hi @ajapczynski ,

There is no native way of doing that, but here is a great example from @JohnJPS .

https://community.alteryx.com/t5/Alteryx-Designer/Multo-row-header/td-p/29185

Best,

Fernando Vizcaino

[ajapczynski]

Thanks that worked!