Data in table is not sorted properly, its scrambled at 10 min mark.

[Destroy]

As you can see, the output gets messed up when 4 decimal places starts.

(Scroll down to the 10 minute mark in the file.)

Is it even possible to have a macro sort this out?

Note, not every table output is the exactly the same making this issue even harder to solve.

[macropod]

Is it even possible to have a macro sort this out?

What constitutes 'sort this out'?

You have cells with content. What do you want to do - delete what doesn't fit, hide what doesn't fit, reformat the content so everything fits, change the cell widths so everything fits, something else?

[Destroy]

Guess by looking at the data I thought it would be pretty obvious.

Like I said, scroll down to the 10 minute mark and you will see the issue I'm having.

I need the table sorted out so all the data is properly in its columns and rows.

[shg]

You're kind of assuming we know what it should look like. Make the columns wider, the font smaller, decrease the cell margins, ...

[Destroy]

I could care less what the format is or looks like, I just want the data straightened out to the proper rows and columns.

It should look like the first 10 rows all the way down. How can you not see this?

[macropod]

Guess by looking at the data I thought it would be pretty obvious

Like I said, scroll down to the 10 minute mark and you will see the issue I'm having.

Nothing is 'obvious'. Sure, I downloaded & examined your file (how else do you suppose I knew what to ask?) but there's nothing 'obvious' about:

I need the table sorted out so all the data is properly in its columns and rows.

Help yourself by answering the questions you've been asked. We're not mind-readers.

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Destroy]

Nothing is 'obvious'. Sure, I downloaded & examined your file (how else do you suppose I knew what to ask?) but there's nothing 'obvious' about:

Help yourself by answering the questions you've been asked. We're not mind-readers.

Wow, if all you people can not see the pattern in the beginning and notice that at around the 10.1 min. mark there is a mess of the data on table, I do not know what else to say. I don't care about font, color, width, etc.. I want all the data to be in the proper sorted order.

I really don't know how else to explain it. The data in the table before the 10.2 min mark and after the 11.9 min mark is normal. All the data in the table between those areas are wrongly placed and scrambled.

[macropod]

The data in the table before the 10.2 min mark and after the 11.9 min mark is normal. All the data in the table between those areas are wrongly placed and scrambled.

OK, so your data are scrambled. How is one supposed to determine programmatically which bits go where? And for all the other tables you say you have that aren't "exactly the same"? Rather like unscrambling an omelete IMHO. Evidently, the data come from a file generated outside Word. You'd do far better to resolve the layout issues at the source than trying to clean them up afterwards.

[shg]

Paul, I leave you to figure out how to make this table look the way it should obviously look. Good luck.

[Destroy]

OK, so your data are scrambled. How is one supposed to determine programmatically which bits go where? And for all the other tables you say you have that aren't "exactly the same"? Rather like unscrambling an omelete IMHO. Evidently, the data come from a file generated outside Word. You'd do far better to resolve the layout issues at the source than trying to clean them up afterwards.

That is why I stated my initial thread title; I'm guessing the output source has some kind of pattern or logic to the scramble. All the numbers are indeed there, they are simply shifted to the side or down causing it to be messed up for several rows.

I've put 2 examples in an Excel file as its easier to manage and see.
See Attached 2.

[macropod]

Again, you haven't answered the question. I cannot tell for sure which of your scrambled data goes where, so how am I (or anyone else) supposed to address that programmatically? What are the rules for unscrambling?
Quite obviously, you're importing the data from somewhere and they're being exported from somewhere else. That somewhere else is where the problem needs to be resolved, not after the mess has been made.