While there are functions in Excel to remove blank rows and combine
data, I think the best approach is to make an adjustment to the source
data. I have found that sometimes for relatively small datasets,
copying and pasting the data in a program like Notepad as a txt file,
then opening it into Excel does the trick.


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=474261