Skip to main content
SFares14-Alexandrite
14-Alexandrite
Sep 18, 2014 3:43 PM UTC
Solved

Pivot table values from excel inserted to a matrix

Hello,

please see attachment . i am manually copying and pasting each value from the pivot table into the matrix. is there an easier way to automate this process? the size of the table can be any square table meaning number of rows= number of columns.Thanks!

StuartBruffAnswer
23-Emerald V
Sep 18, 2014 4:03 PM UTC

You need to generate your header, then stack it on top of the array,

then transpose the header, stack a space on top of it, then augment it to the back of the previous array.

Stuart

View in thread

10 replies

StuartBruff23-Emerald VAnswer
23-Emerald V
Sep 18, 2014 4:03 PM UTC

You need to generate your header, then stack it on top of the array,

then transpose the header, stack a space on top of it, then augment it to the back of the previous array.

Stuart

Translate
SFares14-AlexandriteAuthor
14-Alexandrite
Sep 18, 2014 4:11 PM UTC

Thank you so much Stuart!

Translate
StuartBruff23-Emerald V
23-Emerald V
Sep 18, 2014 4:38 PM UTC

No worries. 🙂

Translate
Terms & ConditionsAccessibility statement