Forum Discussion
Multiple Data in Single Cell with One Corresponding Value In Different Cell
(sample attached)
#1 Format your data range as Table
#2 Click somewhere in the Table
#3 Go to Data (tab) > In Get & Transform Data group click From Table/Range (Power Query Editor opens)
#4 (not mandatory) delete "Changed Type" in APPLIED STEPS
#5 Select column [BMO]
#6 Click on Split Column > By Delimiter
- Check the determined delimiter is OK ortherwise adjust it
- Click Advanced options > Split into: Rows > OK#7 Click Close & Load at the top left corner of the window
1. Yes this is exactly what I need.
2. Excel 365
3. Data is not in a table, but can convert if needed...
Thanks
Mansoor
(sample attached)
#1 Format your data range as Table
#2 Click somewhere in the Table
#3 Go to Data (tab) > In Get & Transform Data group click From Table/Range (Power Query Editor opens)
#4 (not mandatory) delete "Changed Type" in APPLIED STEPS
#5 Select column [BMO]
#6 Click on Split Column > By Delimiter
- Check the determined delimiter is OK ortherwise adjust it
- Click Advanced options > Split into: Rows > OK
#7 Click Close & Load at the top left corner of the window
- Thanks you so much! You are fantastic 🙂 !!! So good to learn something new. I appreciate sharing your knowledge.
MansoorSadat You're welcome. Glad I could help & Thanks for providing feedback
Nice week-end...