My solution will provide you with the results you're looking for. Have
you tried it?

andrewm Wrote:
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


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