Extract data in rows (with line breaks) to form a table

[rei.T]

Hello there! I have a text file contains many members data with lin
breaks separate one from another. How can I extract the data from line
of txt file to form a data table to an excel file? I know I can us
Import txt file wizard in excel. But what i faced is that, not al
members details share the same width and digits as they are in free tex
file.

Would vba helps to extract the details and put them to a table wit
column heads like: Account#, Name, Contact Person, Tel#, Fax#(if any)
Enrollment Date, Expiry Date, Shopping History, Product, Amount?

Thank you for solving my question!!!!

Example:
===================================================
Member Profile ABC Company Created Date 10-Jul-13

Account #
A1234 Name Amy Inc Contact Person Amy xxxxx
Tel# 12345678901
Fex# 123456987

Enrollment Date 10-Jul-13 Expiry Date 10-Jul-18

Shopping History Product Amount
AAA Company AAA product 700
BBB Company BBB product 8000
CCC Company CCC product 900

------------------------------------------------------------------------------
Member Profile ABC Company Created Date 10-Jul-13

Account #
B1234 Name Becky Inc Contact Person Beck
xxxxx
Tel# 12345678902

Enrollment Date 10-Jul-13 Expiry Date 10-Jul-18

Shopping History Product Amount
AAA Company AAA product 700
BBB Company BBB product 8000
------------------------------------------------------------------------------

Member Profile ABC Company Created Date 10-Jul-13

Account #
C1234 Name Charlie Inc Contact Person
Charlie xxxxx
Tel# 12345678903
Fax# 12358546651


Enrollment Date 10-Jul-13 Expiry Date 10-Jul-18

Shopping History Product Amount
DDD Company DDD product 700
EEE Company EEE product 8000

------------------------------------------------------------------------------
Member Profile ABC Company Created Date 10-Jul-13

Account #
D1234 Name David Inc Contact Person Davi
xxxxx
Tel# 12345678904

Enrollment Date 10-Jul-13 Expiry Date 10-Jul-18

Shopping History
AAA Company AAA product 700
FFF Company FFF product 400
GGG Company GGG product 3200