Forum Discussion
Inserting multiple rows in between the existing data set
Hey Can anyone tell me how to insert multiple alternating rows in the existing data set as some so the data needs to be sorted out and i have almost 17k rows that need to be inserted. So can anyone ...
Use the Subtotal option from the Outline group on the Data Ribbon.
Use a column that has unique values.
Then Filter for those rows and Clear contents or edit as necessary