Forum Discussion
Solved
Split column in multiple rows
Hello, I'd be very grateful if you could help me with an issue I've been struggling all the day through. I have data in below format (1st image) where some columns have multiple values separa...
Yes, I overlooked one required adjustment: there is still a "Source" in that line of code, that should be adjusted to #"Promoted Headers".
Hi pect,
You need to use the split into columns mode but with the option split to rows you need to do this for every column below see the steps and final result.
Regards
MFelix
Thank you very much Felix.
I already tried what you propose but if I am afraid this is not what I am looking for. In your example your resulting table has 16 rows but it should only have 8 rows. The way you say it does a cartesian product resulting to repeated values I wouldn't need.
Àlex