Re-arrange table

[BautistaC888]

Hello,
I have the following table:

And i need to re arrange the values by name and ID like this (first row became the first column):

If anyone could help, i will appreciate it.
Thank you.

[AngelosPachis]

Hey @BautistaC888 ,

Here's one way to do it. I used a multirow formula tool to group your table into groups, depending on whether a lowercase single character appears in the description column. Then I joined each group together and renamed the fields as needed.

Regards,

Angelos

[BautistaC888]

Sorry,
The "a,b and c" are names, i just don't wanna put their names public.

[AngelosPachis · Accepted solution]

Hi @BautistaC888 ,

Can you try the attached workflow? I altered my approach as I noticed that records containing people names have a sum of values in columns equal to zero, so I leverage that to isolate them.