Extract using power query or VBA

[aliikhlaq2006]

I have a data that is in raw form i want to extract 3 rows and convert them to the columns. Row are E-mail, company name which is always below member id and rep. I have also bold the rows which need to be converted to columns. I have about 10000 rows of data[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 215"]
<tbody>[TR]
[TD="class: xl65, width: 215"]1. MEMBER ID 2100002-2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 215"]
<tbody>[TR]
[TD="class: xl65, width: 215"]PRIME COLOUR TRADING COMPANY[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 215"]
<tbody>[TR]
[TD="class: xl65, width: 215"]STREET# 5, KUTCHERY BAZAR,[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 215"]
<tbody>[TR]
[TD="class: xl65, width: 215"]FAISALABAD[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 215"]
<tbody>[TR]
[TD="class: xl65, width: 215"]TEL : 041-2626573,2622644[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 215"]
<tbody>[TR]
[TD="class: xl65, width: 215"]MOBILE : 0300-8652090[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 215"]
<tbody>[TR]
[TD="class: xl65, width: 215"]FAX : 041-2622675[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 215"]
<tbody>[TR]
[TD="class: xl65, width: 215"]E-MAIL : yousafdyes@live.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 215"]
<tbody>[TR]
[TD="class: xl65, width: 215"]REP : M.AYUB SABIR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 215"]
<colgroup><col></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]