Look up "Transpose Rows To Columns" in the help files.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Upendra Singhai" wrote in
message ...
I have once sheet with more than 500 blocks of data in this format:


--------------------------------------|-----------------|--------------
comapny1
--------------------------------------|-----------------|--------------
Website: web1
--------------------------------------|-----------------|--------------
Location: loca1
--------------------------------------|-----------------|--------------



How can I convert them to a arranged format like this:
--------------------------------------|-----------------|--------------
COMPANY | WEBSITE | LOCATION
--------------------------------------|-----------------|--------------
company 1 |web1 | loca1
--------------------------------------|-----------------|--------------
company 2 |web2 | loca2
--------------------------------------|-----------------|--------------
company 3 |web3 | loca3
--------------------------------------|-----------------|--------------

Upendra Singhai
______________
visit: www.upendrasinghai.com