Dec 16 2021 07:26 AM
I have an excel spreadsheet with data that has been exported from our practice management system that I want to sort. In the practice management system, we have a list of potential clients and the date that they were added to our waiting lists. Then we have labels assigned to them to identify which waiting lists they are on. When the original file is exported, it puts all of the labels into one column. I have figured out how to get that data separated and each label is put in its own column. Now I want to be able to sort the data to show me anyone who is on each waitlist, and then filter it by the date they were added. However, I can't figure out how to make excel look at all 5 columns at the same time.
So for example, I would like any row that has "speech therapy waitlist" listed in columns I - M to be filtered and then I would sort that data by the date added to the waitlist.
I am using Microsoft Office 365 on a Dynabook Laptop with Windows 10.
Dec 16 2021 07:46 AM - edited Dec 22 2021 05:46 AM
Solution@Jessica_Irish I dare to suggest that you can do all in Power Query (an integrated part of Excel since 2016). Connect to the original export file and let PQ do the rest. No need to split the Labels into separate columns in Excel. Much easier in PQ. Then "unpivot" the lot summarise to your liking. Once set-up, you can repeat it over and over again when the export file changes.
How exactly? That depends on the exact of the export file. Are you familiar with PQ?
Dec 16 2021 07:49 AM
Dec 16 2021 07:56 AM
The link below would be a good place to start.
Dec 16 2021 07:46 AM - edited Dec 22 2021 05:46 AM
Solution@Jessica_Irish I dare to suggest that you can do all in Power Query (an integrated part of Excel since 2016). Connect to the original export file and let PQ do the rest. No need to split the Labels into separate columns in Excel. Much easier in PQ. Then "unpivot" the lot summarise to your liking. Once set-up, you can repeat it over and over again when the export file changes.
How exactly? That depends on the exact of the export file. Are you familiar with PQ?