String Combination Based on Specific Lists

Hello,

What I'm trying to achieve is a method where I'm able to create a specified group name based on three columns. To explain I created a combination of keywords that I needed and the next step is to create a group name based off the keywords created in a specific format. I tried using partial text match with concatenate formula but to no avail. I enclosed a sample of my problem and I apologize in advance if this sounds a bit confusing. Any help with this would be appreciated.

Thanks!

Standardised product naming method/convention, using TRIM and CONCATENATE functions like below:

String Combination Based on Specific Lists.png

Thank you both for looking into this...@DavidBowan I never thought of using powerquery to attain this! Thanks again for taking the time to help with these problem

h2=INDEX($N$2:$N$10,ROW(A4)/4)&" | "&INDEX($P$2:$P$10,ROW(A4)/4)&" | "&INDEX($N$2:$N$10,ROW(A4)/4)&" "&INDEX($O$2:$O$10,MOD(ROW(A4),4)+1)

Thanks CAABYYC! This is brilliant this actually helped solved the problem!