enviouseminence
New Member
- Joined
- Feb 14, 2023
- Messages
- 1
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
Table1
Table2
Column A are all the different types of inputs that could be related to a particular category.
How can I do it in such a way that my output becomes something like this?
| Name | Others |
| Person A | I am interested in doing calculus and trigonometry |
| Person B | coding, making websites |
Table2
| Column A | Subject category |
| websites, mobile application, .. etc | Information Technology |
| mathemathics, calculus, trigonometry | Math |
Column A are all the different types of inputs that could be related to a particular category.
How can I do it in such a way that my output becomes something like this?
| Name | Others | Found Category |
| Person A | I am interested in doing calculus and trigonometry | Math |
| Person B | coding, making websites | Information Technology |
