Forum Discussion

J_o_n_a_s's avatar
J_o_n_a_s
Helper I
1 year ago
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 ...
Need Help
  • AlienSx's avatar
    AlienSx
    1 year ago
    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
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi J_o_n_a_s,

Thank you for reaching out in Microsoft Community Forum.

Thank you AntrikshSharma , SundarRaj , AlienSx , uzuntasgokberk    for the helpful response.

As suggested by AntrikshSharma, SundarRaj, AlienSx, uzuntasgokberk.,  I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.