Forum Discussion
Solved
How to Split Row from Column into New Column
| Input | New Column 1 | New Column 2 |
| Cat | Cat | Birds |
| Dog | Dog | Snake |
| Birds | Fish | |
| Snake | ||
| Fish |
Hi yodkosin
Please tell us your rule to classify the rows.
For example,
concatenate=Table.Group(#"Added Conditional Column","category",{{"new column",each Text.Combine(List.Transform(_[Input],(x)=>x),",")}})Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
yodkosin , What is the logic behind it?
Hi yodkosin
Please tell us your rule to classify the rows.
For example,
concatenate=Table.Group(#"Added Conditional Column","category",{{"new column",each Text.Combine(List.Transform(_[Input],(x)=>x),",")}})Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
