Hi Wouter,

Perhaps if I give you an example of what I have and what I requi

Currently, my SS displays data as:

A B C
D
date interval code
Quantity
May 11 2005 09h00-09h10 AGL 5750
May 11 2005 09h10-09h20 AGL 800
May 11 2005 09h20-09h30 AGL 10121
May 12 2005 09h00-09h10 AGL 3333
May 12 2005 09h10-09h20 AGL 1421
May 12 2005 09h20-09h30 AGL 8364
May 11 2005 09h00-09h10 BAW 16935
May 11 2005 09h10-09h20 BAW 6000
May 11 2005 09h20-09h30 BAW 12225
May 12 2005 09h00-09h10 BAW 22527
May 12 2005 09h10-09h20 BAW 34858
May 12 2005 09h20-09h30 BAW 21659

.....and what I require is.....

A B C
D
date interval AGL
BAW
May 11 2005 09h00-09h10 5750 16935
May 11 2005 09h10-09h20 800 6000
May 11 2005 09h20-09h30 10121 12225
May 12 2005 09h00-09h10 3333 22527
May 12 2005 09h10-09h20 1421 34858
May 12 2005 09h20-09h30 8364 21659

Hope you can assist with this.

Much obliged,
Mohoney


--
Mohoney
------------------------------------------------------------------------
Mohoney's Profile: http://www.excelforum.com/member.php...o&userid=26620
View this thread: http://www.excelforum.com/showthread...hreadid=398970