So what I need to do is come up with a macro that will do the following and save me from 5 hours worth of mind-numbingly-boring transposing and deleting of rows:Ģ) Copy/Paste that selection, then TRANSPOSE onto row one, starting at A1 and going through BH:1 or whatever 60 cells comes out to be horizontallyģ) Then Delete the rows of data that were transposed into row 1 columns (basically delete 60 rows)Ĥ) Then select the NEXT 60 rows of data, and repeat the whole process, but this time pasting into row 2 instead of row 1 (A2:BH2).ĥ) This needs to iterate through the whole worksheet until it cycles through all 12000 rows. To transpose data, first mark the entire data range by. Here’s a quick trick in Excel that can be really handy if you’ve started to enter some data in a row, but decide that you’d like it in a column instead (or vice versa). Each logical record is actually 60 rows of the data. To append this list to mine I first need to convert the rows into columns that is transpose the data. I have an Excel worksheet with 200 "logical records" of data, currently represented by ~ 12,000 rows of data in just one column (A). Select the range of data you want to rearrange, including any row or column labels, and press Ctrl+C. Highlight the data that you want to change in your spreadsheet: the column that you want to change to a row the row that you want to change to a column the data range in which you want to change columns and rows. I have baseline VBA knowledge but not enough to do the following: Excel proposes the fast and simple way to change columns and rows in the data range. OFFSET (BancoG5,0,ROW ()) Now, as you drag it down, it will offset by the number of rows down you go. Could really use your help with this one.
0 Comments
Leave a Reply. |