Insert Blank Rows after certain data

[sjgreyling]

Hi,

I want to insert rows within excel when a column changes data. Say for instance in column C21-C128 has the same data value and then at C129 the value changes again to another value. I want to insert a blank row every time the data changes in that clomn.

Here is an example:

A B C D

20070517 15544087 FIRSTNETAI 6001085000019
20070517 16041650 FIRSTNETAI 6001085000019
20070517 16094047 FIRSTNETAI 6001085000019
20070517 16154080 FIRSTNETAI 6001085000019
20070418 11242902 6001085000019 FIRSTNETAI
20070418 11243148 6001085000019 FIRSTNETAI
20070418 12503867 6001085000019 FIRSTNETAI
20070418 12504096 6001085000019 FIRSTNETAI
20070418 16453877 6001085000019 FIRSTNETAI




There is alot of different values in column C, not just the two within the example.

The end result must look something like: (Also, if its possible to fill a color in the blank row as well)

20070517 16041650 FIRSTNETAI 6001085000019
20070517 16094047 FIRSTNETAI 6001085000019
20070517 16154080 FIRSTNETAI 6001085000019

20070418 11242902 6001085000019 FIRSTNETAI
20070418 11243148 6001085000019 FIRSTNETAI
20070418 12503867 6001085000019 FIRSTNETAI
20070418 12504096 6001085000019 FIRSTNETAI

20070516 4072752 FIRSTNETAI 6001085000019
20070517 4064404 FIRSTNETAI 6001085000019
20070517 4070252 FIRSTNETAI 6001085000019

20070418 10261531 6001001030007 6001085000019
20070418 10261531 6001001030007 6001085000019
20070418 10424851 6001001030007 6001085000019



It will be a great help and big thank you if some can help me on this.

Regards,
Schalk

[jasoncw]

Hi, Schalk. I believe this is what you are looking for.

Please Login or Register  to view this content.

HTH

Jason