Need help with macro to clean up a table of data

You guys have been VERY helpful on things like this before. Need your help again, please!

This is an Excel data dump out of SAGE. Tab1 is how it it comes. Tab 2 is how I am trying to reorg it. In column A, the first number is the SKU, then the following numbers in A are the Location, then a space, then a new item same set-up. I need location broke out into the 2nd column and the SKU in the 1st column and the remaining information following to the right. When the space appears in column A the totals to the right are sums and I do not need the at all.

There are approx 250,000 lines of data in this table so doing by hand will get ugly.