I would like to report data from one area of my worksheet into other separate areas of the worksheet based on the value of a drop-down menu pick. I don't want to move the data, just compile separate lists that report the data. I have attached an example to illustrate what I am looking for. Lastly, the original data has to remain unchanged and unsorted, since other users will be adding and removing lines from this list, and its order must be preserved.
There is probably an easy way to do this, I just don't know what it is. Thanks!
Sorting list example.xlsx
Bookmarks