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.
Solved! Go to Solution.
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
Sorry,
The "a,b and c" are names, i just don't wanna put their names public.
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.