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 ...
Hello,
I found a way to do it, i selected the rows in which i needed to add the alternate rows pasted it in another sheet, added a column gave numbers to it as 1,2,3 and autofilled it till last copied all the cell numbers in that column and again pasted the same numbers below them in that column. Then went on to sort and filter and selected A to Z filter it added the rows in between.
Then deleted the last column and copy pasted the required rows in the original sheet it worked quite well and was very easy to do.
Regards,
Aditya
Hello,
I also wanted to address the same issue, but i did not understand the following:
'Then went on to sort and filter and selected A to Z filter it added the rows in between.'
I also wanted to address the same issue, but i did not understand the following:
'Then went on to sort and filter and selected A to Z filter it added the rows in between.'
- Adams011600 After selecting the rows go to the Sort and filter option and Select the A to Z filter option it will give you the inserted rows in between.
Regards,
Aditya