Split information from one column to others

[ReyDeSirenas]

Hi everyone, I'm having issues with a database. I want to create 4 columns from a single one. Let me explain: There's a column where every cell have "all" the information for an specific project. That cell contains 4 elements of information (some have 3, 2 or even just 1) divided by an "-" if there's more than one type of information.

text 1 - text 2 - text 3 - text 4
text 1 - text 3
text 1
text 1 - text 3 - text 4


Attached is a sample of what I have and I what I need.


Do someone know how can I make that possible? There's 15k rows that I need to filter depending on the text (1,2,3,4)

[6StringJazzer]

Because you have missing fields in the middle, the only way to do this is to provide a detailed specification of the format of data that can appear in each of the four fields. This one is especially confusing:

NO_BUSROLE - NO BUSINESS ROLE

which ends up being just one column with NO_BUSROLE.

It might not be possible at all. If there are only three elements, I see no way to tell the difference between a missing application and missing product name.

I suspect this is going to require VBA, but I can't be sure without seeing your specification.

[MarvinP]

Hi,

Will you allow a Power Query answer for this problem? Can you supply a few more rows of example and what you expect the result to be?

Power Query has a better Split() function where you can do it from the right or left. It also looks like your second column will always have the word "active" in it.

[AliGW]

Why is this query in the Access section of the forum? Is it in fact an Excel query?

[6StringJazzer]

Moved from Access Tables & Databases since the sample file makes it clear that this is an Excel question.