Transforming table challenge

[vehau1]

I need to transform a table to a format that I can work with.

My table looks like this after some transformation:

I need it to be transformed so that it looks like this:

So, what I need is that I want the column header names for all types marked in yellow, to be put in one column, the value of that former columns' row to be placed in its own column ("value"),

and an index, telling me which original row the value came from.

Any suggestions? Thanks

[Ashish_Mathur]

Hi,

The first image is very small - I cannot read anything there.  Share lesser data in a format that can be pasted in MS Excel and also show the expected result.

[v-eachen-msft · Accepted solution]

Hi @vehau1 ,

Here is my sample file.

At first, you need to replace “null” with 0. Then add an index column(Start from 1).
Select “Wellname” and “index” column, click unpivot other columns. Now, you can get the result.

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.