Hyperlink if statement to pick and transpose data

[nobita_bk06]

Hello everyone,

I have been working on a sheet that contains the companies profile.

The data I got from another source, the sheet consists of only one column. the Company Name cell is hyperlinked to their homepage.
Following that cell are the other information. The most difficulty is the following information of companies are not the same size. I need to transpose it to row and collect the data from this sheet.

My idea is that using the hyperlink if statement to pick the name of company and transpose the following cell to another sheet until another hyperlinked cell is met and repeat the process.

the example is depicted in the following table. Is there anyone who has faced this issue? Any help is appreciated. Thank you so much.

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 679"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Công ty TNHH Namidori Footwear [/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Add: 30/3A đường 35, KP5, P. Bình Trưng Tây, Q.2, Tp. Hồ Chí Minh[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Director:Đào Ngọc Anh[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tel:0985519830[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Email:namidorishoes@gmail.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 679"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Công ty TNHH American & Efird Việt Nam [/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 679"]
<tbody>[TR]
[TD]Add: Lầu 2, 7 Lý Tự Trọng, P. Bến Nghé, Quận 1, HCM[/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Director:Juok Kim[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tel:02862962929[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Email:thuyle@amefird.com.vn[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 679"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Consumer Testing & Inspection Center International (Vietnam) Co.,Ltd (Short name: CTIC Vietnam Co.,Ltd) [/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Add:No 103G1, Pham Van Dong Road, Anh Dung Ward, Duong Kinh District, Hai Phong City, Vietnam[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 679"]
<colgroup><col></colgroup><tbody>[TR]
[TD]HCR One Member Co., LTD [/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Add:20 -Hiep Binh,Hiep Binh Phuoc,Thu Duc,Ho Chi Minh [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tel: (84) 37273643[/TD]
[TD][/TD]
[/TR]
[TR]
[TD](84) 37273644[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Email: hoangdonghcr@gmail.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]