Is there an easy way to do a transpose on a square matrix?

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Solved2.12K viewsFormulas and Functions
0

Hello!

If Matrix1:: has two categories, each with 4 items
… and…
if Matrix2:: has two categories, each with 4 items

… is there a way to make Matrix2:: a transpose of Matrix 1? (Preferably, an easy and fast way. Fast being the important of the two.)

I’ve played with a combination of #Category and SELECT() but haven’t been clever enough to figure it out.

Thanks!

Selected answer as best
0

Hi,

Yes, there is the easy way to do a transpose on a square matrix by means the formula. Look at this model, please.

Selected answer as best
You are viewing 1 out of 2 answers, click here to view all answers.

Latest Questions