Forum Discussion
Solved
Splitting a column with multiple data
Hello, I have some data i am currently working with that has the user and date combined together in one column the dates and user ids will change was wondering if there is a way to dyanmically extra...
Create a calc column, if(Text.StartsWith([Column1], "User") then [Column1] else null
Then use fill down to fill the null values:
Fill values in a column - Power Query | Microsoft Learn
Then delete the rows with null counts.
Create a calc column, if(Text.StartsWith([Column1], "User") then [Column1] else null
Then use fill down to fill the null values:
Fill values in a column - Power Query | Microsoft Learn
Then delete the rows with null counts.