Forum Discussion

Centaur's avatar
Centaur
Helper V
4 years ago
Solved

Transpose or Unpivot

Hello,   I have a file  Co Name, Amount and Date are all in separate columns.  I want: Date to be transposed to rows but keep the Co Name and Amount in rows But Group co name.    I am not sur...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    try this (my) last guess!

Centaur's avatar
Centaur
Helper V
4 years ago

Hi Rocco, I think that file is for Power BI (.pbix)?  I do not have that software.  Would you possibly be able to save it as an excel file?  thank you. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

try this (my) last guess!

  • Centaur's avatar
    Centaur
    Helper V
    4 years ago

    Hi Rocco, yes thats it.  thank you.  REally appreciate it.  I am a novice user of PQ.