Would it be easier to move the contents of ONE cell down? Insert a
blank column A, and in A2, enter this formula:
=IF(C1="",B1,"")
This looks at the cell next to the old A1 (in your example
"Colors..."). If it is blank, it puts the value from B1 into A2,
otherwise it leaves the cell blank. Copy this formula down as far as
needed.
Now, with the cell pointer in A2, click DataFilterAutoFilter
click the arrow in A1 and choose NonBlanks.
Now all your data are in single rows.
Does this work for you?
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=479421