I found a quick way to get all data into one column, instead of copying
and paste.

Using excel analysis tool (if there is no Data Analysis, go to help and
install this tool set)

Tool - Data Analysis - Sampling

select input range, sampling period 1, output option.


--
Zawa
------------------------------------------------------------------------
Zawa's Profile: http://www.excelforum.com/member.php...o&userid=32263
View this thread: http://www.excelforum.com/showthread...hreadid=520172