I have a bunch of data in column A that I require copied to an inserted row above or below the existing data. For example the data would go from 1,2,3,4 to 1,1,2,2,3,3,4,4.
I would only like to do it on the cells/rows selected and not on the entire column.