Home

Split Column difficult data

%3CLINGO-SUB%20id%3D%22lingo-sub-532367%22%20slang%3D%22en-US%22%3ESplit%20Column%20difficult%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-532367%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20struggling%20to%20find%20a%20method%20to%20split%20the%20attached%20column.%20This%20file%20contains%20the%20unique%20records%20only.%3C%2FP%3E%3CP%3EPlease%20give%20specific%20steps%2C%20I%20am%20relatively%20new%20using%20Power%20Query%20Editor.%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3ERusch%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EOriginal%20Description%3C%2FSTRONG%3E%3CBR%20%2F%3EBENEFIT%20PAYMENTS%20DES%3ADEPOSIT%20ID%3Axxxxxxxxxxx1073%20INDN%3AMAUZY%20NORA%20CO%20ID%3A9186%3CBR%20%2F%3EBENEFIT%20PAYMENTS%20DES%3ADEPOSIT%20ID%3Axxxxxxxxxxx2073%20INDN%3AMAUZY%20NORA%20CO%20ID%3A9186%3CBR%20%2F%3EBENEFIT%20PAYMENTS%20DES%3ADEPOSIT%20ID%3Axxxxxxxxxxx3073%20INDN%3AMAUZY%20NORA%20CO%20ID%3A9186%3CBR%20%2F%3EBENEFIT%20PAYMENTS%20DES%3ADEPOSIT%20ID%3Axxxxxxxxxxx5073%20INDN%3AMAUZY%20NORA%20CO%20ID%3A9186%3CBR%20%2F%3EBENEFIT%20PAYMENTS%20DES%3ADEPOSIT%20ID%3Axxxxxxxxxxx6073%20INDN%3AMAUZY%20NORA%20CO%20ID%3A9186%3CBR%20%2F%3EBENEFIT%20PAYMENTS%20DES%3ADEPOSIT%20ID%3Axxxxxxxxxxx8073%20INDN%3AMAUZY%20NORA%20CO%20ID%3A9186%3CBR%20%2F%3EBENEFIT%20PAYMENTS%20DES%3ADEPOSIT%20ID%3Axxxxxxxxxxx9073%20INDN%3AMAUZY%20NORA%20CO%20ID%3A9186%3CBR%20%2F%3EBKOFAMERICA%20ATM%2001%2F05%20%23xxxxx4072%20DEPOSIT%20WESTON%20COMMONS%20DAVIE%20FL%3CBR%20%2F%3EBKOFAMERICA%20MOBILE%2011%2F02%20xxxxxx5103%20DEPOSIT%20*MOBILE%20FL%3CBR%20%2F%3EBKOFAMERICA%20MOBILE%2011%2F16%20xxxxxx8349%20DEPOSIT%20*MOBILE%20FL%3CBR%20%2F%3ECounter%20Credit%3CBR%20%2F%3EIRS%20TREAS%20310%20DES%3A%20TAX%20REF%20ID%3Axxxxxxxxxxx0918%20INDN%3AMAUZY%2C%20RUSCH%20S%20%26amp%3B%20NORA%20CO%20ID%3A9111%3CBR%20%2F%3EInterest%20Earned%3CBR%20%2F%3EOnline%20Banking%20transfer%20from%20CHK%209779%20Confirmation%23%20xxxxxx2503%3CBR%20%2F%3EOnline%20Banking%20transfer%20from%20CHK%209779%20Confirmation%23%20xxxxxx9574%3CBR%20%2F%3ERAYMOND%20JAMES%20%26amp%3B%20DES%3ABROKERAGE%20ID%3Axxxxxxxxx0018%20INDN%3ARusch%20and%20Nora%20Mauzy%20CO%20ID%3A1591%3CBR%20%2F%3ERAYMOND%20JAMES%20%26amp%3B%20DES%3ABROKERAGE%20ID%3Axxxxxxxxx2718%20INDN%3ARusch%20and%20Nora%20Mauzy%20CO%20ID%3A1591%3CBR%20%2F%3ESSA%20TREAS%20310%20DES%3AXXSOC%20SEC%20ID%3Axxxxx2297A%20SSA%20INDN%3ANORA%20Y%20MAUZY%20CO%20ID%3A9031%3CBR%20%2F%3ESSA%20TREAS%20310%20DES%3AXXSOC%20SEC%20ID%3Axxxxx4609A%20SSA%20INDN%3ARUSCH%20S%20MAUZY%20CO%20ID%3A9031%3CBR%20%2F%3ESSA%20TREAS%20310%20DES%3AXXSOC%20SEC%20ID%3Axxxxx4609A%20SSA%20INDN%3ARUSCH%20S%20MAUZY%20CO%20ID%3A9101%3CBR%20%2F%3ETHALES%20PENSION%20P%20DES%3AU.S.%20BANK%20ID%3AXXXXX4609%20INDN%3AMAUZY%2C%20RUSCH%20CO%20ID%3A4416%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-532367%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Rusch235
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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies