Multiple Header to column transpose

[Suesue]

Hello,

I want to transpose the below data as of the bottom table layout.

Can you tell me how to do that?

<DATA>

			DS	DS	AC	AC
			Male	Female	Male	Female
HOS1	Old	5000	1	1	1	1
HOS1	Additinal	5000	0.93292	0.92974	0.93397	0.93295
HOS1	Standard	5000	0.89687	0.89976	0.89353	0.89339
HOS2	Old	20	1	1	1	1
HOS2	Additinal	20	0.9425	0.9366	0.93914	0.93002
HOS2	Standard	20	0.92166	0.91849	0.92332	0.91644
HOS3	Old	10	1	1	1	1
HOS3	Additinal	10	0.98935	0.98487	0.99146	0.99125
HOS3	Standard	10	0.95248	0.95702	0.96966	0.97394

<RESULT>

HOS	TYPE	MAX	DS/AC	Male	Female	>> header
HOS1	Old	5000	DS	1	1	>> Value
HOS1	Additinal	5000	DS	0.93292	0.92974
HOS1	Standard	5000	DS	0.89687	0.89976
HOS2	Old	20	DS	1	1
HOS2	Additinal	20	DS	0.9425	0.9366
HOS2	Standard	20	DS	0.92166	0.91849
HOS3	Old	10	DS	1	1
HOS3	Additinal	10	DS	0.98935	0.98487
HOS3	Standard	10	DS	0.95248	0.95702
HOS1	Old	5000	AC	1	1
HOS1	Additinal	5000	AC	0.93397	0.93295
HOS1	Standard	5000	AC	0.89353	0.89339
HOS2	Old	20	AC	1	1
HOS2	Additinal	20	AC	0.93914	0.93002
HOS2	Standard	20	AC	0.92332	0.91644
HOS3	Old	10	AC	1	1
HOS3	Additinal	10	AC	0.99146	0.99125
HOS3	Standard	10	AC	0.96966	0.97394

[Yoshiro_Fujimori]

Hi @Suesue 

I hope it works.

Workflow

[Suesue]

Thank you for your kind response, Yoshiro.
It's working fine.

When I looked at the initial input data, you had combined DS/AC and Gender as headers.

Is there any way to combine the first two rows of data and then set them as headers?

[Yoshiro_Fujimori · Accepted solution]

Hi @Suesue ,

Here is one way of doing this.

I added names for the first 3 columns to the input data.

(But you may also use Select tool to manually put names on those columns)

I hope it works.