Forum Discussion
Solved
Column in table calculated by filter on view
Hello everyone, Solutions Regions Year Solution 1, Solution 2, Solution 3 Region 1 2022 Solution 1, Solution 2 Region 2 2023 Solution 3, Solution 2 Region 3 2022 Solution...
Using Power Query, I would split the Solutions column into rows:
Then trim the leading space in Solutions and you'll have data that is easier to use:
Using Power Query, I would split the Solutions column into rows:
Then trim the leading space in Solutions and you'll have data that is easier to use:
Seems like an great idea. However would it be possible to split column into rows but in another Table as i want data in this table to stay the same.
Sure, you can create a second table in Power Query. Right-click the query and select "Reference", and the new query will point to the original query. Apply the steps above to the new query.
