PDA

View Full Version : Solved: converting multi-dimension array to single-dimension



kualjo
07-28-2010, 11:35 AM
I'm struggling to figure out a way to convert a 2-dimensional array with horizontal data to a 1-dimensional array, or even just a single column of data. Basically, I need to take a data table that is laid out like a calendar going out several months and line it up in a column. Is it necessary to go with an array or is there an easier way to flip the numbers? Once I have a strategy, I think I will be OK.

kualjo
07-28-2010, 12:25 PM
After further digging, I think I can use the TRANSPOSE function to get what I need. The first page will take some work to complete, but I can cut and paste to the other worksheets and workbooks.

I'm learning!