Manipulation of tables in Excel is a pain most time. There is an
excellent .Net application available at http://www.sunfinedata.info/.
The program is called TWE. It can merge, split, extract, join, and
transpose tables as well as dealing with format and duplicates. Please
check it out.


--
zhanshan
------------------------------------------------------------------------
zhanshan's Profile: http://www.excelforum.com/member.php...o&userid=35883
View this thread: http://www.excelforum.com/showthread...hreadid=556774