Make a list with sort group by an id

[Anastasio_Theohari]

Hello everyone,

I have this case,

id            status

3            dog;cat;frog

3            cat;dog;frog

3            dog;cat;frog

4            cat;shark

how can i make id=3 have the same sort?

The desire result will be like this:

id            status

3            cat;dog;frog

3            cat;dog;frog

3            cat;dog;frog

4            cat;shark

Any idea how can i implement this?

Thank you

[atcodedog05 · Accepted solution]

Hi @Anastasio_Theohari 

Here is how you can do it.

Workflow:

Hope this helps : )

[binuacs]

@Anastasio_Theohari Similar to @atcodedog05 approach but using RegEx tool

[atcodedog05]

Happy to help : ) @Anastasio_Theohari 

Cheers and have a nice day!