How to a break a column into a new column?

[Anonymous]

            .

How do I seperate the numbers and the months letter into a new column? I tried the split method but none of the video from youtube are showing me how to break this in half.

Thanks

[kentyler]

So the text month names and the month numbers are mixed into the same column ? Can you show us a screen shot with some sample data ?

[Anonymous]

Correct the month names and month numbers are mixed into the same column. I'm trying to do some date filter but since month names and numbers are mixed, the data is not showing correctly. I posted another picture in my original post.

[Greg_Deckler]

One thought on this, Pivot your column and then choose all of the columns with the numbers and Unpivot those. Then choose all of the columns with text and Unpivot those.

[kentyler · Accepted solution]

Here is a good post on how to use find and replace in power query.

You could either replace the numbers with names, or the names with numbers.

https://www.howtoexcel.org/power-query/bulk-replace-values/
This is a good example of Slogan 1 from https://bislogans.com/3-shape-your-business-data-before-you-load-it-into-power-bi/  fixing problems in your data before you start working with it in Power BI can save you LOTS of problems. In this case you'd be using Power Query to do the fix.

[Anonymous]

Thank you so much 🙂