Hi

I tried looking at the archives but haven't really come across a
similar problem.

In one sheet the data is organised as follows:
Firm 12/5/05 12/6/05 12/7/05 12/8/05
A Event-1 Event-4
B
C Event-3 Event-5
D Event-2
E Event-7

On another sheet this data needs to be organised as follows:

12/5/05
A Event-1
D Event-2
12/6/05
C Event-3
12/7/05
A Event-4
12/8/05
C Event-5
E Event-7

Would appreciate if some one could suggest a way to do this.

Thanks
Utkarsh