Skip to main content
S
SFares14-Alexandrite
14-Alexandrite
September 18, 2014
Solved

Pivot table values from excel inserted to a matrix

  • September 18, 2014
  • 10 replies
  • 3425 views

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!

Best answer by StuartBruff

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

10 replies

S
StuartBruff23-Emerald VAnswer
23-Emerald V
September 18, 2014

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

S
SFares14-AlexandriteAuthor
14-Alexandrite
September 18, 2014

Thank you so much Stuart!

S
StuartBruff23-Emerald V
23-Emerald V
September 18, 2014

No worries. 🙂

Terms & ConditionsAccessibility statement