Hi,

First of all, thank you for reading my question and I greatly appreciate any help I can get. I am new to macros but I am slowly learning. I need to align this data by date and by Account #. There are 2 sets of data and some rows don't have data for every date. I need to align the data to where the data for each date is aligned, and if there is no data for that date in one set, it will be blank on that set row. For example:

I need

1 1
2 3
3 4
4 5

to be

1 1
2 -
3 3
4 4
- 5

but also be aligned by another variable, the account #.

Is it possible to do that? I have attached the spreadsheet I am working on. Example.xls

Thank you so much.