How can I extract one diagonal from it and put it in a column? Please refer to the pictures below
Thank you so much for helping me out
Solved! Go to Solution.
Hi @fsarmien ,
maybe there is an easier way, but the first solution that came to my mind is to add a row number using the Record Id tool, transpose data using the Transpose tool, add column numbers using a Multi-Row Formula tool and select the cells with "Row" = "Column":
What do you think?
Best,
Roland
Hi @fsarmien
Here is my take on this
Workflow:
1. Using record id to set row id.
2. Using transpose tool to convert data columns to rows.
3. Using filter tool to keep only diagonal elements.
Hope this helps : )
Thank you so much for your help! Great community
Happy to help : ) @fsarmien
Cheers and have a nice day!