Help with Power Query

kboakye129

New member
Joined
May 23, 2022
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2019

I am trying to use transform and load on power query to align the below date into 4 columns
Please help

date description credit debit balance

27th Apr FASTER PAYMENTS RECEIPT REF.102 LEIGHAM VALE FROM MCHUGH KE G 70.00 180.36


28th Apr CARD PAYMENT TO DELIVEROO.CO.UK,10.49 GBP, RATE 1.00/GBP ON 26-04-2020 10.49 169.87


4th May CARD PAYMENT TO LB CROYDON,70.00 GBP, RATE 1.00/GBP ON 30-04-2020 70.00 98.47
4th May FASTER PAYMENTS RECEIPT REF.ANOUSHKA BILLIMORI FROM T Billimoria 40.00 138.47
4th May TRANSFER TO MR JOSHUA PETER ROBERTS-MENSAH 4.00 134.47
4th May BILL PAYMENT VIA FASTER PAYMENT TO CORRINE REFERENCE RENT , MANDATE NO 30 50.00 84.47
4th May FASTER PAYMENTS RECEIPT REF.102 LEIGHAM VALE FROM MCHUGH KE G 70.00 154.47
5th May CARD PAYMENT TO DELIVEROO.CO.UK,19.69 GBP, RATE 1.00/GBP ON 02-05-2020 19.69 134.78
5th May CARD PAYMENT TO DELIVEROO.CO.UK,3.68 GBP, RATE 1.00/GBP ON 02-05-2020 3.68 131.10
6th May CARD PAYMENT TO LB CROYDON,60.00 GBP, RATE 1.00/GBP ON 03-05-2020 60.00 71.10
6th May CARD PAYMENT TO DELIVEROO.CO.UK,20.61 GBP, RATE 1.00/GBP ON 04-05-2020 20.61 50.49
7th May CARD PAYMENT TO ALDI STORES LTD,36.88 GBP, RATE 1.00/GBP ON 05-05-2020 36.88 13.61
7th May CARD PAYMENT TO YOGI NEWS 01,13.97 GBP, RATE 1.00/GBP ON 05-05-2020 13.97 -0.36
7th May TRANSFER TO MR JOSHUA PETER ROBERTS-MENSAH 7.00 -7.36
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,149
Reaction score
2
Points
38
Excel Version(s)
365
It really would be easier to supply an Excel workbook or a txt file, however, 2 methods in the attached.
There are probably easier ways.
 

Attachments

  • ExcelGuru11534.xlsx
    23.5 KB · Views: 5

kboakye129

New member
Joined
May 23, 2022
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2019
It really would be easier to supply an Excel workbook or a txt file, however, 2 methods in the attached.
There are probably easier ways.


@ P45cal
My file is in csv format . Can I attach? the system is not allowing me to attach the file
Anyway, I am grateful for your help. I am working it out from the queries to make sense of your queries
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,149
Reaction score
2
Points
38
Excel Version(s)
365
Top