How do I repeat the small row next to the big rows?

**emilio911** · 02-23-2017, 09:27 AM

I have some small rows (of two columns), followed by multiple rows of 7 columns each. I don't know the exact contents of each cell and I don't know how many large rows are following each small rows.

What I want is to move the small rows next the ALL of the following large rows.

I want this:

title1, title2
bla, wla, bla, tra, bla, vla, bla
bla, wa, bla, bla, sla, bla, pla
bla, wa, sla, na, wla, kla, pla
title3, title4
bla, wa, sla, na, wla, kla, pla
bla, wa, bla, bla, sla, bla, pla
bla, wla, bla, tra, bla, vla, bla
bla, wla, bla, tra, bla, vla, bla
bla, wa, bla, bla, sla, bla, pla
title5, title6
bla, wla, bla, tra, bla, vla, bla
bla, wa, bla, bla, sla, bla, pla
title7, title8
bla, wa, bla, bla, sla, bla, pla
...
...

To become this:

title1, title2, bla, wla, bla, tra, bla, vla, bla
title1, title2, bla, wa, bla, bla, sla, bla, pla
title1, title2, bla, wa, sla, na, wla, kla, pla
title3, title4, bla, wa, sla, na, wla, kla, pla
title3, title4, bla, wa, bla, bla, sla, bla, pla
title3, title4, bla, wla, bla, tra, bla, vla, bla
title3, title4, bla, wla, bla, tra, bla, vla, bla
title3, title4, bla, wa, bla, bla, sla, bla, pla
title5, title6, bla, wla, bla, tra, bla, vla, bla
title5, title6, bla, wa, bla, bla, sla, bla, pla
title7, title8, bla, wa, bla, bla, sla, bla, pla
...
...

Thanks all!

**FDibbins** · 02-23-2017, 02:37 PM

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**FDibbins** · 02-23-2017, 02:37 PM

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**FlameRetired** · 02-23-2017, 03:32 PM

Here's one way to do it. Try this formula in H1, fill down and across until you get blanks.

=IFERROR(IF($C1="","",IF(COLUMNS($H:H)<3,LOOKUP(2,1/ISNUMBER(SEARCH("title*",A$1:A1)),A$1:A1),INDEX($A1:$G1,,COLUMNS($H:H)-2))),"")

It is done in the attached.

**emilio911** · 02-23-2017, 06:22 PM

Originally Posted by FlameRetired

Here's one way to do it. Try this formula in H1, fill down and across until you get blanks.

=IFERROR(IF($C1="","",IF(COLUMNS($H:H)<3,LOOKUP(2,1/ISNUMBER(SEARCH("title*",A$1:A1)),A$1:A1),INDEX($A1:$G1,,COLUMNS($H:H)-2))),"")

It is done in the attached.

Thanks 1,000,000 times!

**emilio911** · 02-24-2017, 12:05 PM

Originally Posted by FlameRetired

Here's one way to do it. Try this formula in H1, fill down and across until you get blanks.

=IFERROR(IF($C1="","",IF(COLUMNS($H:H)<3,LOOKUP(2,1/ISNUMBER(SEARCH("title*",A$1:A1)),A$1:A1),INDEX($A1:$G1,,COLUMNS($H:H)-2))),"")

It is done in the attached.

@FlameRetired

Could you please guide me? I would like to modify the formula so that the small rows have 3 columns and the big ones have 9 columns. How could I do that? I had trouble properly understanding the formula...

Thanks again!

**JeteMc** · 02-24-2017, 01:38 PM

Modify Dave's formula so that it reads:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

**emilio911** · 02-24-2017, 01:51 PM

Originally Posted by JeteMc

Modify Dave's formula so that it reads:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Thanks a lot!

**JeteMc** · 02-24-2017, 02:36 PM

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.

How do I repeat the small row next to the big rows?

LinkBack

Thread Tools

Rate This Thread

Display

How do I repeat the small row next to the big rows?

Re: How do I repeat the small row next to the big rows?

Re: How do I repeat the small row next to the big rows?

Re: How do I repeat the small row next to the big rows?

Re: How do I repeat the small row next to the big rows?

Re: How do I repeat the small row next to the big rows?

Re: How do I repeat the small row next to the big rows?

Re: How do I repeat the small row next to the big rows?

Re: How do I repeat the small row next to the big rows?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Number of rows too small now

Count Comma Delimited values in Cell, Convert to rows, Repeat Remaining info next to Rows

Convert 1 row of data to 4 rows and have it repeat every 4 rows

[SOLVED] Delete blank rows between data rows, shift rows up, then repeat

[SOLVED] Rows to repeat - printing, how do I "not" repeat these rows on last page

Need to Move data from Rows 8,10,11 and 13 to row 8 and repeat for rows below

Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions