I have data presented in groups of 12, eg. if i have 36 data points, they are
currently in 3 rows, each roll containing 12 points. I want to plot a graph
of all 36 points. How can i tell excel that after grabbing the 12 cells in 1
row, it should automatically go to the next roll to capture the next 12 and
then the 3rd row for the last set of data? I know i can copy and manually
rearrange the data all onto one row so Excel can read properly. However, i
have over 200 sets of these data (each with 36 data points).

Any help will be greatly appreciated!!!!

Thanks!