Forum Discussion
ebecerra
Microsoft Employee
Microsoft EmployeeCreating 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:
jdbuchanan71
Super User
Super UserHello 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:
ebecerraMicrosoft Employee
Microsoft EmployeeOMG Thank you jdbuchanan71! You're brilliant!