EXERCISE + STATUS (Ability to perform, symptoms, difficulty etc)
I have a list of exercises that my clients perform. When they see me, I enter some information around their ability to perform the exercise and if they could do it, any pain while doing it and other things.
The tracking list of statuses for each exercise is about 15 different items. Each exercise can have multiple statuses recorded.
IDEAL
So I would like to be able to quickly see what the status is for each exercise (per client). So I know what they have done before, what they still need to do and the problems they had with some of the exercises.
THE PROBLEM
For space when looking at exercises while with a client, I would like the status in one cell.
Creating my key is causing some problems so I thought I would reach out to see if there is a smart way to create a status key so that I will be able to use pivot tables etc to better visualise a clients list of exercises and their ability to perform exercises.
See attached file.
Hi Dom,
I'm not sure what you mean by 'creating your key'.
However, if you want to input the status in a single cell, you could then use Power Query to split the statuses in the single cell into separate cells/rows based on the comma separator, then you can easily visualise the data in a PivotTable.
If I've misunderstood the process, perhaps you could show the steps in the Excel file, so I could follow the stages you go through and the desired results at each stage.
Mynda
