combine columns with text, move over columns with number

Hello. I have a sample file with dates in the first two rows (leave those be) and then other stuff below. I would like to combine the text columns into just one column and then move the rest of the info over to the left so that it's under the dates. How would I do this with a code that will loop through all rows? Thanks. Spreadsheet attached.

If this is not what you wanted, need to see your desired result and the clear explanation.

Please Login or Register  to view this content.

Hmmmm, not really. This is a better example.

HAHAHHAAH. That's the whole point of this vba exercise. I'm copying in the data from a PDF (it's a couple of hundred rows long). That's the cleanest I can get it. The vba is supposed to clean it up by combining the text columns and then pullling the numbers to the left.

Perhaps. But at the moment, I'm working with what I'm working with and your comments don't really help with my post.

Let's just pretend it wasn't from a data dump and it was from a messy internal report from IT, which happens quite often.

It's not a better example, but different.