![]() ![]() 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. Each logical record is actually 60 rows of 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). Sometimes you build a line chart or column chart off of data and Excel puts data in the wrong spots. If you need to reshape your worksheet for further processing, use this add-in's functionality and get quick results. I have baseline VBA knowledge but not enough to do the following: I show how to change the Column and Row of an Excel Chart very easily. Change rows to columns and vice versa with Transpose Range How to transpose data in Excel The Transpose Range tool flips rows and columns in your table. ![]() 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. Could really use your help with this one. Excel proposes the fast and simple way to change columns and rows in the data range.
0 Comments
Leave a Reply. |