add rows according to cell value

[josekr80]

Hello,
Hope someone can help me.
I have a table, in column A every 2 cells are merged (1+2,3+4...). In column B, no merged cells, and every cell has a number. Column C, I need to add rows according to cell value on B. But in a way that columns A and B will stay merged. Something like this:
A. B1. C1=2. Row
Row added
B2. C2=3. Row
Row added
Row added
Thanks a lot in advance.

 

[DanteAmor]

Hello,
Hope someone can help me.
I have a table, in column A every 2 cells are merged (1+2,3+4...). In column B, no merged cells, and every cell has a number. Column C, I need to add rows according to cell value on B. But in a way that columns A and B will stay merged. Something like this:
A. B1. C1=2. Row
Row added
B2. C2=3. Row
Row added
Row added
Thanks a lot in advance.

You could rewrite your requirement there are a couple of inconsistencies.

You mention that B is not merged and then you say that it should will stay merged.
You say the numbers are in B but then in your example you put the numbers in C.
You could put 2 images, an image with the original data and another image with the result.

Upload an excel image:
https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html