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.