Code:
--------------------

A B C
In the diamond =IF(ROW()=MATCH(A1,A:A,FALSE),VLOOKUP(A1,$C$1:$C$3 ,1,FALSE),"") In the diamond
In the diamond =IF(ROW()=MATCH(A2,A:A,FALSE),VLOOKUP(A2,$C$1:$C$3 ,1,FALSE),"") Trench Safety
In the diamond =IF(ROW()=MATCH(A3,A:A,FALSE),VLOOKUP(A3,$C$1:$C$3 ,1,FALSE),"") The City
The City =IF(ROW()=MATCH(A4,A:A,FALSE),VLOOKUP(A4,$C$1:$C$3 ,1,FALSE),"")
The City =IF(ROW()=MATCH(A5,A:A,FALSE),VLOOKUP(A5,$C$1:$C$3 ,1,FALSE),"")
The City =IF(ROW()=MATCH(A6,A:A,FALSE),VLOOKUP(A6,$C$1:$C$3 ,1,FALSE),"")
Trench Safety =IF(ROW()=MATCH(A7,A:A,FALSE),VLOOKUP(A7,$C$1:$C$3 ,1,FALSE),"")
--------------------


The Row()=MATCH() code just tells it to put in a blank if this isn't
the first occurance of the tex in column A. I used vlookup to return
the values in column C if it mached the item in column A.

This code takes your exact input and produces your exact output...but I
don't know if it will do you what you want in reality :).


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=486009