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,169
Reaction score
11
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,169
Reaction score
11
Points
38
Excel Version(s)
365
Top