Here is An all in one tool, you can stack your list and easily format them the way you want once imported. As well as store your list in the tool for easy access. Also you can stack the list you have stored together to find the matches.
EXCEL ORGANIZER TOOL - QUICKLY FORMAT MULTIPLE LIST
This tool will allow you to modify your excel sheets and save all the steps, give the task a name and next time import, select that format and export your results in seconds.
It’s easy when you have a uniform set of data that consists of “First Name” & “Last Name”. But if you are dealing with combinations, you soon realize that just splitting the name into “First Name” & “Last Name” with a couple of commands on Excel will not do the trick!
Suppose you have an excel file that you want to separate the categories in one column to multiple folders. Some folder will have what is in one keyword and some will be made out of multiple categories.