Skip to content
Advertisement

Get Row value as Column Header

I have two tables as below. I want to join these two tables and need to set the column values of second table as column header as shown below. How can I achieve this?

Table1 

table2

The output table should be

Advertisement

Answer

You can use Dynamic Pivot as below-

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement