Add blank rows

[Closed]
Report
Posts
3
Registration date
Tuesday October 22, 2013
Status
Member
Last seen
October 24, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
explain the logic of different number of blank rows.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
3
Registration date
Tuesday October 22, 2013
Status
Member
Last seen
October 24, 2013

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
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
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/