Insert Line Every Other Row

**rosethorn5** · 08-03-2015, 05:12 AM

Hello,

I was wondering if there is a quick and easy way to insert a row in between every line item that I have, so that it is on every other row. Right now, I have formulas down 50 rows, and would like to have a (different from the existing, but same and consistent content) line every other so that it is alternating.

I hope that is clear. Below is an example:

Currently:
Content A
Content A
Content A

I would like it to be:
Content A
Content B
Content A
Content B
Content A
Content B

I appreciate it!

**Glenn Kennedy** · 08-03-2015, 05:32 AM

Something like this, maybe...
=IF(ISODD(ROW()),$C$1,$D$1)

where C1 and D1 contain the texts that you wish to alternate...

**seasider89** · 08-03-2015, 06:03 AM

Another solution would be to insert the new data undernath the old data, then number them as follows. Once you have entered the first couple of numbers you can drag down and it will continue the pattern. Then sort the numbers ascending and delete the column.

A 1
A 3
A 5
A 7
B 2
B 4
B 6
B 8

**popipipo** · 08-03-2015, 06:41 AM

Here another one
Enter in an empty column each row (1-10) a number from 1 to 10 and row 11 to 20 also 1 to 10 (row 11 to 20 are empty)
Then sort everything on that column and there is a empty row after each row

**rosethorn5** · 08-03-2015, 05:08 PM

Hello Glenn,

Thank you - what do I put in the parenthesis after ROW?

I am wanting to repeat in an alternating fashion down Column B, not across row C,D,E... so If I want it to go down my B column, would I enter in the data I want for B1, B2, then in B3 enter in the "IF(ISODD ..." formula then drag it down?

**rosethorn5** · 08-03-2015, 05:11 PM

I don't know how to delete this

**rosethorn5** · 08-03-2015, 05:13 PM

I don't know how to delete this

**nigelbloomy** · 08-03-2015, 05:36 PM

This site has an interesting method as well.
http://www.pcmag.com/article2/0,2817,1785247,00.asp

**newdoverman** · 08-03-2015, 06:07 PM

This might work for you:

Formula:

Please Login or Register  to view this content.

MOD(ROW(),2)=1 when filled down a column produces 1 and 0 alternating down the column starting with 1 if starting in the first row.

If you change to MOD(ROW(),2)=0 when filled down a column produces 0 and 1 starting with 0 if starting in the first row.

If the formula starts on an even row, the above MOD formulae are reversed.

If the values are in one column like column A this will work:

Formula:

Please Login or Register  to view this content.

**rosethorn5** · 08-03-2015, 07:28 PM

Thank you all - my problem is that the information that I want to alternate down a column include formulas, which contain specific cells in that corresponding row. When I go to enter something in those cells that correspond to those formulas, it repeats them in every single alternating cell down that column. I need to repeat these formulas in an alternating fashion down this column but all be independent from each other. Is this possible? Or do I have to enter the formulas alternating every row, then manually select the corresponding cells for every single line?

**newdoverman** · 08-03-2015, 08:01 PM

This will combine the contents of columns A and B into a single column alternating between column A and column B. The construction of the formulae in the columns will determine if they still work or not. This starts in row 1.

Formula:

Please Login or Register  to view this content.

If the data starts in row 2 use this and the combined column will start the combined values in row 3.The firs value will be a 0...delete it.

Formula:

Please Login or Register  to view this content.

**Glenn Kennedy** · 08-04-2015, 12:43 AM

What are the two formulae that you want to incorpoate? In which row should each one begin?

**samba_ravi** · 08-04-2015, 01:38 AM

rosethorn5, will you please attach sample excel with with expected result

**rosethorn5** · 08-04-2015, 02:22 AM

Below are the two formulas which I would like to alternate every other row down one column. They need to be independent from each other.

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Below are two other formulas in which I need to alternate every other row down one column:

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

**Glenn Kennedy** · 08-04-2015, 02:35 AM

Put this in A5 or any other column, row 5, and copy down

Formula:

Please Login or Register  to view this content.

**Glenn Kennedy** · 08-04-2015, 02:40 AM

And in B3, or any other column, row 3:

=IF(ISODD(ROW()),ROUNDUP(O3*2.3,0),ROUNDUP(O3*2,0))

BtW, you don't put anything between the () of row(). It's just looking at the row and dertermining if its and odd-numbered row or an even-numbered row. The IF function makes it return one formula if its an odd-numbered row and another formula if its an even numbered row.

**rosethorn5** · 08-04-2015, 03:48 AM

Originally Posted by Glenn Kennedy

Put this in A5 or any other column, row 5, and copy down

Formula:

Please Login or Register  to view this content.

YES!! This is perfect. Thank you SO MUCH!!!

**rosethorn5** · 08-04-2015, 03:54 AM

Glenn - why does the first, longer formula start in row 5, and the second, shorter formula start in row 3? Both of these formulas correspond with each other.

Row 1 & 2 are labels for my chart, so I start my data in row 3. For each of the two formulas (Concatenate & Roundup), do I need to enter the formulas in row 3 and 4, then the "IF(ISODD(ROW()), ...." formula in row 5? or Can I start in row 3?

Thank you!!

**Glenn Kennedy** · 08-04-2015, 03:55 AM

You're welcome and thanks for the Reputation.

**rosethorn5** · 08-04-2015, 04:08 AM

Nevermind - I figured it out. Thanks again so much Glenn!!

Insert Line Every Other Row

LinkBack

Thread Tools

Rate This Thread

Display

Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Re: Insert Line Every Other Row

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Where more than 1 line exists in excel transfer - insert line in word report bookmark

[SOLVED] VBA - Help on insert line

Insert a line at zero value in a line graph

Insert Line Every Other Row w/Multiple Formulas based on Line Above

Insert Line

Insert New Line

Insert Line maintaining formatting and formulas from preceding line

Insert each line in a new row

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions