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.
v-jingzhang
Community Support
Community SupportHi 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.