nobita_bk06
New Member
- Joined
- Jan 1, 2018
- Messages
- 1
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.
<tbody>
</tbody>
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.
Add: 30/3A đường 35, KP5, P. Bình Trưng Tây, Q.2, Tp. Hồ Chí Minh | |||
Director:Đào Ngọc Anh | |||
Tel:0985519830 | |||
Email:namidorishoes@gmail.com | |||
<tbody> </tbody> | |||
Director:Juok Kim | |||
Tel:02862962929 | |||
Email:thuyle@amefird.com.vn | |||
<colgroup><col></colgroup><tbody> </tbody> | |||
Add:No 103G1, Pham Van Dong Road, Anh Dung Ward, Duong Kinh District, Hai Phong City, Vietnam | |||
Add:20 -Hiep Binh,Hiep Binh Phuoc,Thu Duc,Ho Chi Minh | |||
Tel: (84) 37273643 | |||
(84) 37273644 | |||
Email: hoangdonghcr@gmail.com | |||
<tbody>
</tbody>