convert file from text to column with uneven rows

[kvisaria]

I want to convert file from text to column
but only issue is some rows are not aligned as others. I have attached text file and sample excel file that it should look like after conversion.

Text file -
IEEE Credit Memo Register
30-JUN-18 18:17
IEEE Service Center Trx Date From: 27-MAY-2018 To: 30-JUN-2018 Page: 1


Invoice Credit Memo Invoice Orig. Invoice Amount
Credit Memo # Credited Customer Name Customer # Date Date Code Amount Credited
-------------- ----------------- ---------------------------- ------------ ----------- ----------- ----- -------------- --------------
Reason: CANCELLATION

Product #: ----- GL Account #: XX-XXXX-00000-12345-RENEW-00000

203790 X-XXXXXXXXXXX Sam AAAAAAAAAAA XXXXXXXX 30-MAY-18 21-MAY-18 USD 45.99 0.00
203791 X-XXXXXXXXXXX John ddddddd XXXXXXXX 31-MAY-18 30-MAY-18 USD 152.50 0.00
-----------------
Total Amount Credited By Product # / GL Account # 0.00


30-JUN-18 18:17
IEEE Service Center Trx Date From: 27-MAY-2018 To: 30-JUN-2018 Page: 2


Invoice Credit Memo Invoice Orig. Invoice Amount
Credit Memo # Credited Customer Name Customer # Date Date Code Amount Credited
-------------- ----------------- ---------------------------- ------------ ----------- ----------- ----- -------------- --------------


Product #: ----- GL Account #: XX-XXXX-10000-21110-XXXXX-00000

203791 X-XXXXXXXXXXX John EEEEE XXXXXXXX 31-MAY-18 30-MAY-18 USD 152.50 0.00
203791 X-XXXXXXXXXXX John EEEEE XXXXXXXX 31-MAY-18 30-MAY-18 USD 152.50 0.00

-----------------
Total Amount Credited By Product # / GL Account # 36.30




Sample excel output that I need -

GL ACCOUNT NUMBER CREDIT MEMO CM NUMBER INVOICE CUSTOMER NAME CUSTOMER NO CM DATE INVOICE DATE CODE ORIG INV CREDITED
REASON AMOUNT AMOUNT

XX-XXXX-00000-12345-RENEW-00000 CANCELLATION 203790 X-XXXXXXXXXXX Sam AAAAAAAAAAA XXXXXXXX 30-May-18 21-May-18 USD 45.99 0.00
XX-XXXX-00000-12345-RENEW-00000 CANCELLATION 203791 X-XXXXXXXXXXX John ddddddd XXXXXXXX 31-May-18 30-May-18 USD 152.50 0.00
XX-XXXX-10000-21110-XXXXX-00000 CANCELLATION 203791 X-XXXXXXXXXXX John EEEEE XXXXXXXX 31-May-18 30-May-18 USD 152.50 0.00
XX-XXXX-10000-21110-XXXXX-00000 CANCELLATION 203791 X-XXXXXXXXXXX John EEEEE XXXXXXXX 31-May-18 30-May-18 USD 152.50 0.00

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...xt-format-excel-format-macro-post5098613.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.