Triangle Data Transpose

jaydelim16

I am looking to update the data triangles on the "input" tab to obtain the triangles on the "output" tab of the attached.  Basically, the values in the last diagonal in the input triangles should become the first column of the output triangles, and so on.  Thank you!

Triangle Transpose.xlsx

atcodedog05

Hi @jaydelim16 

Here is my take on the interesting usecase 🙂.

Workflow:

1. Using record id tool to set row id.

2. Using transpose tool to convert data columns to rows.

3. Using filter tool to keep only non emppty rows.

4. Using multir-row formula tool setting col order id by grouping on record id.

5. Using sort to reverse on col order id.

6. Using multir-row formula tool setting col rev order id by grouping on record id.

7. Using join tool to map and get reverse col order id's col name.

8. Using crosstab to convert it back to table.

Hope this helps : )

Triangle Transpose.yxmd