Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
4 years ago
Solved

UnPivot Mental Block

Hi all,

 

I'm have a mental block trying to UnPivot some data

Here's the mock-up in Excel. No matter what I try to UnPivot in PowerQuery I cannot get the final layout.

 

Thanks,

-w

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Maybe it's not unpivot that you need...you are trying to make the top table into the bottom table? If I assume that you have column headers, you could just use Table.Transpose(TableNameOrLastStepName), then just promote your headers.

    --Nate

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Maybe it's not unpivot that you need...you are trying to make the top table into the bottom table? If I assume that you have column headers, you could just use Table.Transpose(TableNameOrLastStepName), then just promote your headers.

    --Nate

    • UncleLewis's avatar
      UncleLewis
      Responsive Resident
      4 years ago

      Thanks Nate,

       

      I imported the table
      Demoted the Header Row to First Row
      Transposed the Table
      Promoted First Row to Header Row

      Looks great - thanks!

      -w