Pivot Question and group by

[GeekAlfPro]

Hello,

i'm facing an issue and don't know how to resolve it.

i have datas like this : 

and i want to transform like this, where the _6 column have only one row

i tried several things (pivot fill up and so on), but without success

any help would be welcome !

[Anonymous · Accepted solution]

let
    Origine = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dY6xDoAgDET/pbMLtKXyLcQBEzed9P9jDwZigstB8njclUKBFgrJY6/3gbsg1GhbCsUpFG5QdE7zoJEz/r/q2WrMQzpNU9cGdFW7ihErTO3UpmrutfozygblwOxHfbAJL00+0BpEa4SbXd1e", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [id = _t, poste = _t, libelle = _t, nombre = _t, taux = _t]),
    #"Raggruppate righe" = Table.Group(Origine, {"id"}, {{"all", each Table.First(_)},{"sal", each Record.FromList(List.Skip(_[taux]), List.Skip(_[poste]))}}),
    #"Tabella all espansa1" = Table.ExpandRecordColumn(#"Raggruppate righe", "all", {"poste", "libelle", "nombre"}, {"poste", "libelle", "nombre"}),
    #"Tabella sal espansa" = Table.ExpandRecordColumn(#"Tabella all espansa1", "sal", {"2391", "2395", "3133", "3137"}, {"2391", "2395", "3133", "3137"})
in
    #"Tabella sal espansa"

[GeekAlfPro]

Hello @Anonymous 

thank you very much that's exactly what i tried to do.

have a good day

[Anonymous]

help who can help you: upload a table that can be easily copied!