How to get the column name as the value

[cyg3003]

hi all, I have two tables or more as the source data, as the pics below.

the two left tables are supposed to be unioned like the right table.

I dk how to make it? the workflow sample is attached.

Any suggestions will help. Many thanks!

Molly

[gabrielvilella · Accepted solution]

Hi @cyg3003, you can use the Transpose tool and then Union.

[grazitti_sapna · Accepted solution]

Hi @cyg3003, another way of solving the problem.

Thanks!

[cyg3003]

wow, thanks for your kind help, these two ways both work and  I learn a lot.