I have around 85K worth of Rows and around 10 Columns. i am filtering the data into subgroups to look at same data sets.
For Example -
i have a row and in one of the cells its has Heat and Sounder. i need to duplicate the row completely and drop it below its respective row. Making two duplicated rows.
i can then change the top two rows and copy and paste so each of the duplicate sets has one being heat and one sounder.
i can carry out a copy and insert paste row which is fine for the odd duplicate required. But when i have 100 odd it can be time consuming.
Anyone have any ideas how to make this easier?
For Example -
i have a row and in one of the cells its has Heat and Sounder. i need to duplicate the row completely and drop it below its respective row. Making two duplicated rows.
i can then change the top two rows and copy and paste so each of the duplicate sets has one being heat and one sounder.
i can carry out a copy and insert paste row which is fine for the odd duplicate required. But when i have 100 odd it can be time consuming.
Anyone have any ideas how to make this easier?