Member multiple row data in column

Hope all members are fine, I would like to know that how i convert following row data in their specific column e.g. columns are (COMPANY NAME, ADDRESS, CITY, REPRESENTATIVE, PHONE 1, PHONE 2, FAX, EMAIL, WEBSITE) i have around 500+ members data in row

M/S ASMY DYEING & PRINTING MILLS (PVT) LTD.,
68-INDUSTRIAL ESTATE, KOTLAKHPAT,
LAHORE
REPSHEIKH MUHAMMAD AYUB)
PH: 35110967-68-69 (MILLS/OFFICE)
PH: 35110967-68-69 (MILLS/OFFICE)
FAX:35122770
E-MAIL: asmy@wol.net.pk
WEBSITE: www.asmydyeing.com


M/S AL-HAMRA HOSIERY & TEXTILE MILLS (PVT) LTD.,
6-K.M., JIA MUSA,
SHEIKHUPURA ROAD,
LAHORE
REPMR.MUHAMAD RASHID RANA)
PH: 37921449 (MILLS)
PH: 37928570 (OFFICE)
FAX:37928571
E-MAIL: ahsanrana@hotmail.com
WEBSITE:


M/S ATTA SONS
OLD G.T.ROAD, SHAHDARA MORE,
LAHORE
REPMR. MUHAMMMAD KASHIF SHEIKH)
PH: 37920899-37930680 (MILLS)
FAX:
E-MAIL:
WEBSITE:


All members support waiting.

Regards.

MJI

Maybe you can attach a sample workbook so we can work something out for you.

Originally Posted by arlu1201

Maybe you can attach a sample workbook so we can work something out for you.

Thanks

I hereby attached data for your work and support