I need a google sheets script. I will paste in a cell a few words and the script will list the words it found in the cell into 6 columns based on their category which will be defined from a list.
Check the screenshot to see a sample of the layout of how I want it to look and how it should function.
1. User pastes the text they want to check in cell D1
2. The script scans the list and the cell and shows the results on the right side of the spreadsheet in different columns.