Power Query PBI

[Train23]

Hello does anyone know how seperate a column in Power Query that contains Text and Numbers but the different data types are on seperate rows.  I would like to seperate the rows with Text into a single column and the rows with numbers into another single column.  See example below, this data is coming into PBI as "web" and is the export of a report.

[Anonymous · Accepted solution]

Hi,

Thanks for the solution Omid_Motamedise  offered and i want to offer a different way for user to refer to.

hello @Train23 , you can create a custom column.

Number.From(Text.Select([Column1],{"0".."9"}))

Outptut

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RedTdot]

Spoiler

[Train23]

THANK YOU YOLO this is exactly what I needed, it worked like a charm.

Train23

[Omid_Motamedise]

Just select your column, go to the home tab and then select split column, out of all the types, pick split change non digit to digit as the next image

If this answer helped resolve your issue, please consider marking it as the accepted answer. And if you found my response helpful, I'd appreciate it if you could give me kudos. Thank you!

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...