I am looking for a way to insert rows automatically with a formula or some other function. I have large spreadsheets where the data will be the same in a certain column for two to 50rows. When that data changes in that column, I want a row...
I am looking for a way to insert rows automatically with a formula or some other function. I have large spreadsheets where the data will be the same in a certain column for two to 50rows. When that data changes in that column, I want a row inserted before the new data item. I've searched ?Help with no solution. Is there a way to do this so I don't have to go line by line looking for the data to change, then manually adding a blank row between the changed data?
Linear Mode
