The data I am working with has stock symbols in row 1 and workdays in column A. Within the matrix I have dividend prices that correspond to the symbol and the date in which they occurred.What I am trying to sort in this order: date, next cell to the right of that is the the stock symbol and next cell the dividend amount. There will be 4 lines of the same symbol as dividend is payed out on 4 different dates within the year. Index(Match(Match will not work as I also need to grab the first row and column themselves.
Data Example AA BAC CAT DE XOM F GE HO
3/24/2004 .41
3/27/2004 .34
3/28/2004 .76
3/29/2004
3/30/2004 .23 .12
3/31/2004
4/3/2004
4/4/2004 .12
6/24/2006 .41 .04

Example of output
Date Symbol Div Amount
3/24/2004 CAT .41
3/27/2004 BAC .34
3/28/2004 XOM .76
3/30/2004 DE .23
3/30/2004 HQ .12