Hi,

Sorry

sheet 1 contains all of -
column a column b column c column d
date 15/7 16/7 ...
andrew E R
john R E
mary W R
jim R W


it is a roster for 4 people showing what they are doing in each day
either E,R, or W

I would like to rearrange it to sheet 2 showing

column A column B column C column D
column
E W
R R
l
15/7 andrew mary john
jim
16/7 john jim
andrew mary etc

andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=387140