Macro to align rows based on matching values

[Corleone]

Hi - I would like to generate some code which sorts the cells in columns A:D and columns F:I and inserts blank cells where required so that the entries are always aligned based on the value in Column A and Column F - so if you look at the example above - after the macro is run it will look this this....

The columns under the grey header are A:D and the green header F:I

Thanks

 

[akmatz]

Question: Will every entry in column B always exist in column G, and visa-versa?