Hello all, I have non-adjacent data I wish to make a line graph from (see below). The raw data is not in normal from to be visually appealing - so I attempted to turn the data into a more graphable form in another location in the worksheet. So column K lists the dates in order with a simple 'add 1 to the previous cell' formula with K1 as =A3 and K2 as K1+1. However, I want an easy way of pulling the variable data from A6 to L1, A18 to L2, A30 to L3 and so on. I can't find a function to pull this off without having to do it manually. It's been 3 years since I used Excel professionally and I apologize if this is a no brainer. Thanks

ie
A2 - Date
A3 - July 9

A5 - Sales
A6 - 123

A14 - Date (always 12 cells from previous, in this case - from A2)
A15 - July 10 (same 12 cells from previous...

A17 - Sales (12 from previous...
A18 - 234 (and so on...)