Power Query help spitting data from a column into multiple new column
Hey guys, I'm a pretty novice power query user but I've managed to learn a few things along the way but with this one, Im stuck.
I have a column, lets call it "Equipment". In that column are rows that can have any or all of the following values: ball, club, hoop or bat. When two or more exist in the cell, they are separated by a /. There is always a space then a number associated with the ball, club hoop or bat. For example:
Ball 23/Bat 25/Hoop 12/Club 17
What I want to do is create individual columns for those items and have only those items appear in their respective columns. I've tried splitting the column, pivoting the column, and creating conditional columns but I just cant seem to get it right.
So in my mind it would look something like this, using the example above:
| Name | Equipment | Ball | Club | Hoop | Bat |
|---|---|---|---|---|---|
| Tim | Ball 23/Bat 25/Hoop 12/Club 17 | Ball 23 | Club 17 | Hoop 12 | Bat 25 |
Does that make sense? I would delete the equipment column once the new columns have been created, if that helps.
Thanks!
[link] [comments]
Want to read more?
Check out the full article on the original site