Search and return value if text begins with across multiple columns

[peterlongley]

I am hoping that this makes sense and that somebody might be able to point me in the right direction.

I have a dataset from SQL where it had a column containing text with a , seperator.

e.g. Column1 containing "US - Utah, T - KYC Analyst, A - Compliance" on one row and say "T - KYC Analyst, A - Compliance, US - Utah" on another (so no order of how they were entered)

I have seperated the columns by the column delimiter and now how around 15 columns containing each different text set.

I would like to create a column for each begins with so that they are in a proper order as currently they could be each in there own column for filtering etc.

So I would like it to have results in new columns for each entry returned.

Column 1 containing all that start "US -"

Column 2 containing all that start "A -"

Column 3 containing all that start "T -"

Have searched and cannot find out how I can achieve this across multiple columns containing the data.

[Ahmedx]

Column 2 containing all that start "A -"
Column 3 containing all that start "T -"
you can have spaces here, so I don't advise you to check the letters

[Ahmedx · Accepted solution]

I created two variants for you, be careful, you need to check the right words

https://1drv.ms/u/s!AiUZ0Ws7G26Rh1Etg2BU65uIhHDM?e=DDiMGz

[peterlongley]

Thank you so much, that solved the issue for me. Much appreciated 😀

[Ahmedx]

Is this what you are looking for?

[peterlongley]

Exactly that, are you able to show me the full query that you used?