In the attached picture you can see the excel sheet I am working on right now, I need to make a graph of the placement of a orbiting sphere.
On one axis there needs to be the x-placement and on the other axis the y-placement. It has to be a spread graph so you can see the placements over time.
Problem is, as you can see in the picture, the x and the y value are beneath each other in every step, but aren't organised in a table.
Since there are over a thousand steps in the sheet organising by hand isn't an option. Is there any way of systematically arranging this data if the distance between the x-values and the y-values between different steps is constant?
Thanks in advance, if you're not feeling like posting an entire tutorial you could also give some keywords so I can look it up myself.
Bookmarks