Anya_TFrequent Visitor4 years agoSolvedRow to Column Hi, I have huge daily incoming data in this format Manager User Id Column 2021-19 anukshag brabhis Actual TIM Time (hrs) 47.99 anukshag brabhis Actual overlap TIM Time (hrs) 47...Show Moreryan_mayu4 years agoAnya_T i think you can use pivot in the PQ = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Column]), "Column", "2021-19")
ryan_mayu4 years agoAnya_T i think you can use pivot in the PQ = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Column]), "Column", "2021-19")
ryan_mayu4 years agoAnya_T i think you can use pivot in the PQ = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Column]), "Column", "2021-19")
ryan_mayuSuper User4 years agoAnya_T i think you can use pivot in the PQ = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Column]), "Column", "2021-19")
Related contentColumn to RowGrouping rows by Column and then updating ColumnColumn to RowApply data to all rows in a filtered columnAdd duplicate row based on column
