Forum Discussion
Solved
Creating a table from another table's column based on a regular expression
Hi everyone, this is the problem I have. I have this table with a column with some "string" that I need to split into different rows based on a regex. Let me show you what I mean. I have this tab...
Hello ebecerra ,
You can load the data into PowerQuery then use the Split Column by DigitToNonDigit and then Unpivot then Split Column by NonDigitToDigit. I put together a quick video showing the steps:
Hello ebecerra ,
You can load the data into PowerQuery then use the Split Column by DigitToNonDigit and then Unpivot then Split Column by NonDigitToDigit. I put together a quick video showing the steps:
OMG Thank you jdbuchanan71! You're brilliant!