Hi All,

I have what I believe to be a simple problem, but for the life of me, i can't seem to figure it out.

Each month, I get a list of the top 150 advertisers and the dollar amount spent on 8 different online sites.

Many of the top advertisers across these 8 online sites are duplicated but not all.

So, what I end up with is several list of sites with corresponding dollars but it's not organized as a whole.

My goal is to MATCH and ALIGN the data across rows and down columns so that EACH ROW has the SAME advertiser and their corresponding dollars spent.

Example:

......Column A....Column B....Column C....Column D
ROW1: Expedia....$3,200 ........................
ROW2: ....................... Expedia ....$5,300

Desired result:

......Column A....Column B....Column C.....Column D
ROW 1: Expedia ..$3,200........Expedia ...$ 5,300

Any help would be much appreciated.

Thanks
bob