Aligning Data Points in a single Table

[mecheng83]

Hello,

First time poster but I've watched many of Mr. Excel's videos. What I'm looking for is a way to align data points within a table.

Currently I have a table of equipment as the first column and each additional column is the total mileage at the end of the year. Because each piece of equipment doesn't start at the same mileage point, I want to take this information and align the mileage data points in new columns so that all the ~5,000 mile data points are one column, ~10,000 miles in column 3 and so forth. Any guidance would be appreciated.

Thanks