Forum Discussion
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: ...
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
This works really well, thank you, but is there any way of making the count of Count dynamic? At the moment, the "Split Column by Delimiter" splits into Count.1 - Count.4. What happens if one of my IDs has more than 4 notes? Thanks.
