Aligning rows in order to consolidate

Hi guys

I'm working in a company, which are using excel alot. I have created a Datawarehouse with all the company balance for the last 48 months.

This means that all the account numbers (??) used for the last 48 months are in this datawarehouse. So every month I have to align these new account numbers with the old ones in order to be able to consolidate for all the business units.

My question is if there is a simple way to align these account numbers automatically so i dont have to align them manually.

I have attached a sample of what im dealing with every month, i hope it would make my problem more clear to you.

In advance, thanks.

thanks guys that spared me for 4 hours of work every single month.

stanleydgromjr can you tell me how you made that macro ?