Forum Discussion
Multiple text search
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!
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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
How does your original data look like? Why would you use a comma seperator?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
