I have a expanding table of data that I am looking to convert into a flattened structure so that I can import into a fixed SQL format table. The number of columns will continue to expand as time goes on and what I need to do is reference the ever expanding number of rows when required and columns each month to the output format. For Excel VBA I know that I need the last row and column for the data which is on Sheet1, and that the I will need to loop both the row and column to ultimately push the data to the ending range of the last cells in Sheet2. Samples of Data table structures are below.