Forum Discussion
Splitting a column with multiple data
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.
Hello,
I actually found a way to do it similar as you put above but using contains then doing a few or options for the the year upto 2026 to make it more dynamic with the user id side as that was a demo and it wont always be user but a client name that can change. I then used downfill down on the client name left and filter blank rows out.
Example steps for anyone else attempting:
#"Added Conditional Column" = Table.AddColumn(#"Removed Top Rows1", "Custom", each if Text.Contains([Column1], "2022") or Text.Contains([Column1], "2023") or Text.Contains([Column1], "2024") or Text.Contains([Column1], "2025") or Text.Contains([Column1], "2026") then null else [Column1]),
#"Filled Down" = Table.FillDown(#"Added Conditional Column",{"Custom"}),