Please help me with this problem. I have data in the following format
(millions of rows!!)

date (but if text format) 11/11/2001 - thursday
procedure code, operator code
procedure code, operator code
etc. (number of rows variable for each day)
date 12/11/2001 - friday
procedure code, operator code
procedure code, operator code
etc. (number of rows variable for each day)

I need to transpose the date (in date format) from the first row to a
new column cell for all the following rows of that day. Then detect a
new day and do the same,.. Hope that makes sense and thanks ahead of
time.


--
peteracain
------------------------------------------------------------------------
peteracain's Profile: http://www.excelforum.com/member.php...o&userid=26026
View this thread: http://www.excelforum.com/showthread...hreadid=393773