Do some Excel Work

There are around 800 law firms in Hong Kong. And in each law firm, there is 1 to 10 lawyers.

The list of law firms is on [url removed, login to view]

You can click to the english name and generate a list of its lawyers.

I need to get an excel file so that I can generate label to send documents to all these individual lawyers.

For example, in [url removed, login to view]

I need the name in english in 1 column, chinese name of that law firm in another column, telephone in 1 column, email in another, english address in 1 column, followed by chinese address in next column. Then each consultant, partners and associate lawyers in separate rows.

So that each lawyer can be listed in different row and with his/her law firm info.

I attached an example and estimate it can be automated.

数据输入 数据处理 Excel

项目ID： #10754118

关于项目