Add blank rows

Closed
bijnan Posts 2 Registration date Tuesday 22 October 2013 Status Member Last seen 24 October 2013 - 23 Oct 2013 à 11:54
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 25 Oct 2013 à 00:25
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 14 June 2009 Status Contributor Last seen 7 August 2021 811
24 Oct 2013 à 00:24
explain the logic of different number of blank rows.
bijnan Posts 2 Registration date Tuesday 22 October 2013 Status Member Last seen 24 October 2013
24 Oct 2013 à 12:06
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
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
25 Oct 2013 à 00:25
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/