Posted: 1/12/2015 3:17:36 PM EDT
|
I'm trying to insert a certain number of rows in-between existing rows...
Example: I have a column with 50 rows each with unique data. I need to insert 25 rows in-between each existing row without having to click "insert" 25 times. or even highlighting 25 rows below an clicking "insert." There's got to be a faster way to accomplish this... A data1 data2 data3 data4 to A data1 (25 rows) . . data2 25 rows) . . data3 25 rows) . . data4 25 rows) . . |
|
I'd add a dummy column at the far left, and populate the first 50 rows with odd numbers as follows: A1 would be the number 1 A2 would be the formula =A1+ 2 Copy and past the formula from A2 into A3 through A50. Similarly populate A51 through A100 with even numbers. A51 would be 2 A2 would be =A51+ 2 Copy and past the formula from A52 into A53 through A100. Then copy the contents of column A, and Paste Special it back in to column A specifying only Values. That gets rid of the formulas. Sort the whole sheet by Column A. Drop Column A. Profit. |
|
Quoted:
I'd add a dummy column at the far left, and populate the first 50 rows with odd numbers as follows: A1 would be the number 1 A2 would be the formula =A1+ 2 Copy and past the formula from A2 into A3 through A50. Similarly populate A51 through A100 with even numbers. A51 would be 2 A2 would be =A51+ 2 Copy and past the formula from A52 into A53 through A100. Then copy the contents of column A, and Paste Special it back in to column A specifying only Values. That gets rid of the formulas. Sort the whole sheet by Column A. Drop Column A. Profit. Is this adding a single row between each? |
|
kutools
Is the fast easy non-cheat way, for $40 (unsure if there is a trial) |
|
check out this Excel add on package. There is a function for inserting blank rows. Free download and trial period.
ASAP Utilities |
| Unfortunately, I don't have a better suggestion than the insert thing. Without knowing exactly what you're doing, I'd take this opportunity to reevaluate your use of excel. I'm guessing this sheet either needs to be structured differently or housed in something like Access. Purely a guess, and not too helpful for right now but might avoid future headaches. |
|
Quoted: Is this adding a single row between each? Quoted: Quoted: I'd add a dummy column at the far left, and populate the first 50 rows with odd numbers as follows: A1 would be the number 1 A2 would be the formula =A1+ 2 Copy and past the formula from A2 into A3 through A50. Similarly populate A51 through A100 with even numbers. A51 would be 2 A2 would be =A51+ 2 Copy and past the formula from A52 into A53 through A100. Then copy the contents of column A, and Paste Special it back in to column A specifying only Values. That gets rid of the formulas. Sort the whole sheet by Column A. Drop Column A. Profit. Is this adding a single row between each? Yes. The temporary column A acts as an index that you are force-populating with values. It will work with a million rows as easily as it does with 100. I use Excel to manipulate data a lot. Since you have thousands of rows you'll have to adjust the instructions to fit. Your populated rows get odd numbers in column A, then you create an equal number of blank rows populated with even numbers.  |
|
Quoted:
Unfortunately, I don't have a better suggestion than the insert thing. Without knowing exactly what you're doing, I'd take this opportunity to reevaluate your use of excel. I'm guessing this sheet either needs to be structured differently or housed in something like Access. Purely a guess, and not too helpful for right now but might avoid future headaches. I can't count the number of times I've seen excel hacked up to act like database app. I also guessing that if you are trying to add 25 pieces of information to each of your main pieces of data (initial columns), you should be importing it into Access. Think of Excel as a fancy calculator/tabulation and graph tool. If you need to organize information (names/numbers/etc) in addition to calc and graph, you should be using a database app, Access being a common and easy to use one. |