cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Pivot table values from excel inserted to a matrix

SOLVED

Re: Pivot table values from excel inserted to a matrix

Ah, I see you've beaten me to the punch, Werner 🙂

And the image helps to explain the lines ... The first two lines iterate over the header string one character at a time (the substr function), convert the loop index number to a string, concatenate the 'letter' and the 'number' together, and then assign the result to a vector. The other difference of particular note from the original function is that I've created a standard column vector rather then a row vector, simply because it's slightly easier to work with. Hope that helps.

Stuart

Announcements