Attempting to transpose columns but..

[Anonymous]

Hi, I'm trying to do something like a transpose to my imported excel sheet, so i can match the columns it to an existing table

Here's the original data

Here's what I'm trying to do

I added a new column, and I need to put the ID in each row in that new column the corresponding ID from the value field, so it looks like this.

Easy to do in excel but not easy to do in power bi (so far),
How do we do this in powerBI? Is this enough information?

[MFelix · Accepted solution]

Hi @Anonymous,

To do this you need to use the unpivot option. Select the column Investment then go to unpivot and select unpivot other columns result below:

If you want the Column Investment priority to also be kept has is select both columns before the unpivot

[Anonymous]

Thanks very much. Your advice helped me out.