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

1. MEMBER ID 2100002-2 <tbody> </tbody>

PRIME COLOUR TRADING COMPANY <tbody> </tbody>

STREET# 5, KUTCHERY BAZAR, <tbody> </tbody>

FAISALABAD <tbody> </tbody>

TEL : 041-2626573,2622644 <tbody> </tbody>

MOBILE : 0300-8652090 <tbody> </tbody>

FAX : 041-2622675 <tbody> </tbody>

E-MAIL : yousafdyes@live.com <tbody> </tbody>

REP : M.AYUB SABIR <tbody> </tbody>

<tbody>
</tbody>

<colgroup><col></colgroup><tbody>
</tbody>