Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
icturion
Resolver II
Resolver II

parse data values to table

Hello,

 

Is it possible to convert data in a column that is space separated into a separate records and then apply a value from another column per record?

 

The value in column "SAMPLE_IDS" are seven characters long and separated by a space. Every value in this column needs to be a record. Per record de the Value of column "DEPOT_ID" needs to be applied.

 

hopefully this is possible en someone knows how?

 

table.JPG

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@icturion 

Yes you can, In Power Query, Right-Click on the SAMPLE_IDs column, choose Split Column > By Delimiter>
Select Space and Delimiter and Rows under Advanced Options like below

Fowmy_0-1600240816686.png

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@icturion , Try  In power query split column into rows. see if that can help

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Fowmy
Super User
Super User

@icturion 

Yes you can, In Power Query, Right-Click on the SAMPLE_IDs column, choose Split Column > By Delimiter>
Select Space and Delimiter and Rows under Advanced Options like below

Fowmy_0-1600240816686.png

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.