Forum Discussion

BrianPBI37QF's avatar
BrianPBI37QF
Frequent Visitor
3 years ago
Solved

Transpose/Pivot/Unpivot

Hi All,

 

I have a simple issue which I seem to struggle with. I know there is a sequence for transpose/pivot/unpivot to have a single row for each "Workpack - Phase" with the "fnshDate" in separate columns as such:


Much grateful for some help,

B.

Need Help
Show and Tell
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    NewStep=Table.Combine(Table.Group(PreviousStepName," Workpack - Phase",{"n",each Table.RemoveLastN(Table.FromColumns(Table.ToColumns(_)&{List.Skip([fnshDate])},Table.ColumnNames(_)&{"Custom"}),1)})[n])

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    3 years ago

    NewStep=Table.Combine(Table.Group(PreviousStepName," Workpack - Phase",{"n",each Table.RemoveLastN(Table.FromColumns(Table.ToColumns(_)&{List.Skip([fnshDate])},Table.ColumnNames(_)&{"Custom"}),1)})[n])