This question is asked better with the help of an example.....

I have a spreadsheet with data in following format....

ColumnA ColumnB ColumnC ColumnD
date1 1 abc
date1 2 def
date1 4 ghi
date2 2 abc
date2 5 ghi
date2 1 def
date2 6 abc
date3 4 def
date3 7 abc

and I would like to get this data in the following format....

date1 date2 date3 date4
1 abc def
2 def abc
3
4 def
5 ghi
6 abc
7 abc


and then I need to do further processing on this data (which I can do).

Basically what I am looking for is, in my first spreadsheet identify each row by a given date (columnA) and corresponding value in columnB of that row, and now find a cell that is intersection of these ColumnA and ColumnB values in second spreadhseet and fill in the value of ColumnC (from spreadsheet 1) into that intersection cell in second spreadsheet. As my first spreadsheet changes very often I am trying to get my second spreadsheet modified with those changes and then everything else I have in second spreadsheet will also change automatically.

Any help is appriciated.
Thanks,
Jay