Add blank rows

Closed
bijnan Posts 2 Registration date Tuesday October 22, 2013 Status Member Last seen October 24, 2013 - Oct 23, 2013 at 11:54 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 25, 2013 at 12:25 AM
Hello, I am facing a problem in my excel sheet. i shall highly grateful to you if kindly give me a solution to my problem.
In b column of the sheet , the values are like
1
2
4
6
6
7
10
10
10
12
by adding blank rows i want make the column b like this
1
2
one blank row
4
one blank row
6
6
one blank row
7
two blank rows
10
10
10
three blank rows
12

thank you

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 24, 2013 at 12:24 AM
explain the logic of different number of blank rows.
bijnan Posts 2 Registration date Tuesday October 22, 2013 Status Member Last seen October 24, 2013
Oct 24, 2013 at 12:06 PM
well sir. it depends on the missing no and equal no. for example. if column value
1
2
4
then a blank row will be inserted between 2 and 4
and if the values are like
1
2
2
3 one row will be inserted immediate after two same value.
then
0
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 25, 2013 at 12:25 AM
no. taht is not what I had problem

you have one blank row , two blank rows and thre blanks rows.
I prepared a macro to insert one blank row after two values and one value and and again two rows one blank row and one value one blank row looping it over. but you must hve logic of when 2 blank rows are inserted and when 3 blanks rows are inserted/