Split Column difficult data

Highlighted
Frequent Visitor

I am struggling to find a method to split the attached column. This file contains the unique records only.

Please give specific steps, I am relatively new using Power Query Editor.

Thank you,

Rusch 

 

Original Description
BENEFIT PAYMENTS DES:DEPOSIT ID:xxxxxxxxxxx1073 INDN:MAUZY NORA CO ID:9186
BENEFIT PAYMENTS DES:DEPOSIT ID:xxxxxxxxxxx2073 INDN:MAUZY NORA CO ID:9186
BENEFIT PAYMENTS DES:DEPOSIT ID:xxxxxxxxxxx3073 INDN:MAUZY NORA CO ID:9186
BENEFIT PAYMENTS DES:DEPOSIT ID:xxxxxxxxxxx5073 INDN:MAUZY NORA CO ID:9186
BENEFIT PAYMENTS DES:DEPOSIT ID:xxxxxxxxxxx6073 INDN:MAUZY NORA CO ID:9186
BENEFIT PAYMENTS DES:DEPOSIT ID:xxxxxxxxxxx8073 INDN:MAUZY NORA CO ID:9186
BENEFIT PAYMENTS DES:DEPOSIT ID:xxxxxxxxxxx9073 INDN:MAUZY NORA CO ID:9186
BKOFAMERICA ATM 01/05 #xxxxx4072 DEPOSIT WESTON COMMONS DAVIE FL
BKOFAMERICA MOBILE 11/02 xxxxxx5103 DEPOSIT *MOBILE FL
BKOFAMERICA MOBILE 11/16 xxxxxx8349 DEPOSIT *MOBILE FL
Counter Credit
IRS TREAS 310 DES: TAX REF ID:xxxxxxxxxxx0918 INDN:MAUZY, RUSCH S & NORA CO ID:9111
Interest Earned
Online Banking transfer from CHK 9779 Confirmation# xxxxxx2503
Online Banking transfer from CHK 9779 Confirmation# xxxxxx9574
RAYMOND JAMES & DES:BROKERAGE ID:xxxxxxxxx0018 INDN:Rusch and Nora Mauzy CO ID:1591
RAYMOND JAMES & DES:BROKERAGE ID:xxxxxxxxx2718 INDN:Rusch and Nora Mauzy CO ID:1591
SSA TREAS 310 DES:XXSOC SEC ID:xxxxx2297A SSA INDN:NORA Y MAUZY CO ID:9031
SSA TREAS 310 DES:XXSOC SEC ID:xxxxx4609A SSA INDN:RUSCH S MAUZY CO ID:9031
SSA TREAS 310 DES:XXSOC SEC ID:xxxxx4609A SSA INDN:RUSCH S MAUZY CO ID:9101
THALES PENSION P DES:U.S. BANK ID:XXXXX4609 INDN:MAUZY, RUSCH CO ID:4416

0 Replies