Forum Discussion
Solved
Pivot / Unpivot?
Hi. I got this table below and i want to convert it to the table underneath it. I'm assuming to use Pivot/unpivot but can't figure out how. Thanks for your input! PM Pro_Key Inv_No Adj_Due ...
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], tm = List.TransformMany( Table.ToList(Source, (x) => x), (x) => List.Split(List.Skip(x, 3), 2), (x, y) => List.FirstN(x, 3) & y ), result = Table.FromList(tm, (x) => x) in result
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
tm = List.TransformMany(
Table.ToList(Source, (x) => x),
(x) => List.Split(List.Skip(x, 3), 2),
(x, y) => List.FirstN(x, 3) & y
),
result = Table.FromList(tm, (x) => x)
in
resultThanks. This worked. And so did SundarRaj's reply. Got a quesition for AlienSx.
I would like to add more columns. So instead of only the first 3 columns being repeated on each row (like in my initial example) I would like 9 columns to be repeated on each row. So i will add 6 more columns before column Adj_Due _Date1. What would be the solution for that?
And what if then i added another column and made it 10?
Thanks once again
Calculate position of Adj_Due_Date1 in the list of column names and replace 3 in my code with that number.
