Dynamically Convert Matrix to Columns
Posted on 2010-11-22
I am trying to create a way to create rows or individual records from a matrix.Attached is an example. Using formulas or VBA, I'd like to be able to go from a matrix (3x3, for example) to 9 rows of 3 columns. It's hard to explain without looking at the file, but if I had 3 students each with 3 values, I'd like to go from the table array to individuals records (3 for each student). Can anyone lead me in the right direction.