VBA script to match rows with blanks and move entire rows.

Hello everyone, I am barely new here and I registered because I am desperate as I cannot find out the way to get a macro to work properly.

I would like to know if there is someone who can help me out with this.

I have two data tables like this

(I used dashes to delimitate the two tables because it does not allow me to do it in another way )

column A = code
column B = type
column C = price

STORE A ---STORE B
A B C ---A B C

1 A 5 ---1 B 3
1 B 4 ---1 A 5
2 A 3 ---2 A 4
3 A 3 ---3 A 3
4 A 4 ---4 A 4
4 B 2 ---4 B 3
5 A 3 ---6 B 3
7 A 3 ---6 A 5
7 B 2 ---* * *


And I would like to get a VBA script to compare the two tables and align the entire row based on code and type. so I can get something like this.

STORE A ---STORE B

A B C ---A B C

1 A 5 ---1 A 5
1 B 4 ---1 B 3
2 A 3 ---2 A 4
3 A 3 ---3 A 3
4 A 4 ---4 A 4
4 B 2 ---4 B 3
5 A 3 ---* * *
* * * ---6 B 3
* * * ---6 A 5
7 A 3 ---* * *
7 B 2 ---* * *

There was someone who could make it in this forum ( http://www.mrexcel.com/forum/excel-q...ta-blanks.html ) however that VBA only aligns one cell and I need to align the entire row.

Is anybody out there who can help me out, I would be eternally grateful.

Thanks!.