I wish to use a macro in Google Sheets to
- find the number 1 in column A
- then move that corresponding row and all following rows down to start at A9 row
- then find the number 2 in column A
- then move that corresponding row and all following rows down to start at A25
- then find the number 3 in column A
- then move that corresponding row and all following rows down to start at A41 and so on down to number 24.
Each number 1,2,3,... has a varying number of data rows below it before the next number and so I can't simply do one "paste" at A9 with all of the information being in the correct place.
I have tried recording a macro using FIND menu item but it does not work.