Originally Posted by
starguy
Copy data from sheet1 to sheet2
In sheet2 col B put serial numbers against your data in col A (i-e 1, 2, 3... downward).
copy serial # in col B and paste 7 times in col B at first blank cell. e.g if you have data in col A in range A1:A50, put serial # in col B in range B1:B50 then copy B1:B50 and paste in B51 then in B101 and onward for 7 times.
Select both columns A & B till last serial # in col B then go to Data > Sort > and sort Ascending on col B. (you will see 7 blank cells in col A under each value of data).
Now select col A till last value plus 7 cells, press F5 and hit Special tab and select Blanks from options and press Ok (all blank cells will be selected).
Press = and then hit up arrow only once and press Ctrl+Enter.
Copy col A and right click > Paste special, check Values, press Ok.
Delete col B.
Hope this will do what you require.
Bookmarks