Forum Discussion

rdgbasilio's avatar
rdgbasilio
New Member
4 years ago
Solved

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 ...
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

     

ddpl's avatar
ddpl
Icon for Solution Sage rankSolution Sage
4 years ago

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