I have data obtained from an outside source where I want to copy a certain cell to another skipping every 8th cell using autofill. For example:

Results
A1 =A1 =A2 =A3
A2 =A4 =A5 =A6
A3 ... and so on.
A4
A4
A6

Ultimitly I want to graph the data from each column on the same graph.