Forum Discussion

AJPF's avatar
AJPF
Helper I
4 years ago
Solved

pivoting columns

Hello all,    I have some data (only 2 columns) which looks this:    ID Note 100 This 100 is 100 an 200 example 200 of 200 what 300 I  300 need  300 to 300 see   What I want is this: ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    AJPF 

    you can try this

    1. group by

    = Table.Group(#"Changed Type", {"id"}, {{"Count", each Text.Combine([NOTE]," "), type nullable text}})

    2. split the new column by space

    3. change the column name

    pls see the attachment below

     

parry2k's avatar
parry2k
Super User
4 years ago

AJPF Although ryan_mayu  solution is awesome I will not go that route, reason if you have one ID with let's 8 columns, it will create 8 columns for each ID with a blank value and that is unnecessary. From my point of view, it is not efficient. Just my 2 cents. Good luck!

 

 

AJPF's avatar
AJPF
Helper I
4 years ago

When I have more time, I may try your solution.  I just needed something quick and easy to get the report out!  Thanks.