Results 1 to 4 of 4

Thread: Help with Power Query

  1. #1
    Neophyte kboakye129's Avatar
    Join Date
    May 2022
    Posts
    2
    Articles
    0
    Excel Version
    2019

    Help with Power Query



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,115
    Articles
    0
    Excel Version
    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.
    Attached Files Attached Files

  3. #3
    Neophyte kboakye129's Avatar
    Join Date
    May 2022
    Posts
    2
    Articles
    0
    Excel Version
    2019

    Help with Power Query

    Quote Originally Posted by p45cal View Post
    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

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,115
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by kboakye129 View Post
    Can I attach?
    Worst case, change the extension to .zip and tell us what it should be changed back to (or actually zip it up).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •