Multiple text search

[rdgbasilio]

Dears,

I hope you all are doing well!

I have tasks that are applied to multiple users. I have to count the tasks by user and filter it by user too. 

I splitted the users by the separator "," but it generated too much collums. Is there another way to do this?

Task	User
A	1, 2, 3, 6, 8, 15
B	2, 4, 5
C	1, 3, 8, 7

Thanks in advance!

[Anonymous · Accepted solution]

Hi @rdgbasilio ,

I splitted the users by the separator "," but it generated too much collums.

Did you splitted your table as below? This may casue too much columns in your new table.

I suggest you to try split into Rows in Advanced options. Then you will get a new table which is splited into rows and this may make the calculation easier for you.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tamerj1]

@rdgbasilio 

How does your original data look like? Why would you use a comma seperator?

[ddpl]

Try this:

Step1 : First split the user as per bwlow:

Step 2 : Then transpose the data by selecting first column

result was: 

Step 3 : Use first raw as header:

 Result was: 

Then go to destop and drop the column in table as per requirement

Please accept as solution if it works