The way to get around the need for double entry is to use a data base program instead of a spread sheet. Once you become familiar with program, you just load the data in and can retrive it in a number of ways.
If learning a new program is not what you want to do, then in your
Excel spreadsheet, use only one sheet, and then sort by the catagory you want. That is, list them alphbeticaly, but then sort by your location or other category when you need to look that up. When done, either don't save the sort or re-sort by the column you want to keep it organized by.