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