Assuming your data in rows 8 to 52 is in columns A and B, put the
following formula in column c on rows 8 to 52:-

=IF(AND(ISBLANK(A8),ISBLANK(B8)),"",TEXT(B8,"$##") &" "&A8&"; ")

Then in the cell where you want the description:-

$10 Because I said so; $16 Who is asking;

enter the following:-

=TRIM(C8&C9&C10&C11&C12&C13&C14&C15&C16&C17&C18... ........&C52)


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=502534