Forum Discussion
Dunner2020
Post Prodigy
Post ProdigySpliting a row into two rows based on column value
Hi there, I have a dimension table that has a 1:M relationship with the fact table as shown in the following picture: In the fact table, ContributingFactor may contain multiple...
Hi Dunner2020
Please refer to this article: Split by Delimiter into Rows (and Columns) with Power Query
Under Home tab, select Split Column > By Delimiter.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
lbendlin
Super User
Super UserYou can deconstruct the rows in Power Query. Use Character.FromNumber(9) to find the tabs (or let the Power Query editor do it for you).
Please provide sample data in usable format (not as a picture) if you want sample Power Query Code.