Dynamically Convert Matrix to Columns
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.
TommySzalapski
You didn't attach anything. And it is hard to see what you mean. Do you just want to transpose the matrix? If so just use copy and paste special->transpose.
ASKER
Oops. Sorry. Attached is the spreadsheet.
Converting-Matrix-to-Columns.xlsx
Converting-Matrix-to-Columns.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
AWESOME, Tommy! I guess there is no way to do it with formulas, huh?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Wow! Perfect! Thanks, Tommy. I hope you are in here more often. Great insight!
ASKER
Just what I needed, much faster than I could have ever hoped! Thanks.