Forum Discussion
How to ...
This one is a fun one, so here are the list of steps (need to be done in Power Query):
1) Split your status column by position (1 character) -> this will create a separate colum for the letter prefix and the number
2) Remove Duplicates -> this ensures only unique values on our rows
3) Group All Rows by the Letter column (Status.1)
4) Add a Custom Column to add a List of records (the numerical ones)
5) Click on Extract Values (expanding the Custom column) and select "-" as the custom delimiter
6) Expand All Data column and extract Building column, then remove again duplicate rows
7) Use the merge columns feature to join Letter column with list of values
And there you go!
This one is a fun one, so here are the list of steps (need to be done in Power Query):
1) Split your status column by position (1 character) -> this will create a separate colum for the letter prefix and the number
2) Remove Duplicates -> this ensures only unique values on our rows
3) Group All Rows by the Letter column (Status.1)
4) Add a Custom Column to add a List of records (the numerical ones)
5) Click on Extract Values (expanding the Custom column) and select "-" as the custom delimiter
6) Expand All Data column and extract Building column, then remove again duplicate rows
7) Use the merge columns feature to join Letter column with list of values
And there you go!
ray_aramburo I had to change my datamodel a little bit but with your play by play I got it to work
Glad it worked! 🙂
