Merging multi-line Narration into single in Bank Statement
Vložit
- čas přidán 7. 09. 2024
- This tutorial demonstrates trick to merge narration / remarks in Bank Statement running into multiple lines into single line, using various Excel functions like CONCAT, XLOOKUP, ISNUMBER. The trick can be applied to Bank Statements converted from PDF into Excel, where-in decoding algorith is not able to detect multi line narrations, converting it into separate row.
I've looked at many solutions to this problem, and this one is by far the easiest and best. Thanks for sharing.
Oh wow🎉 Thank you, I’ve had so much trouble with this scenario.
Perfect, we need more this type of data shortage videos
Much wanted video. Many thanks for sharing
Sir.... Very useful trick for my works..... Thanks a lot.... ❤
Thanku sir to giving me one another useful method.
Good way of life , thanks for your sharing
It helped me a lot brother. Thanks.
Thank you sir for helping as
How could we solve if the same date is repeated more than once in the date column with different narration and we need separate narration on the same date as stated above?
This technique would work irrespective of date is repeated or not. Date column is just acting as placeholder for logic of determination of narration start/end
I’m struggling with combining Dr side and Cr which are separately recorded in different column. Dr line is above Cr line. So it’s hard to merge them into single column for account code.
This might be the fix for this. Conceptual demo below:
=A2 (Debit Amount cell)
In adjacent cell, write formula
=A3 (Credit amount cell)
Now if you copy paste these two cells till bottom, you will get debit credit amount in the single row. Just delete repetition in the adjacent rows
Awesome
Thanks for the video any possibility in power query
It is possible in Power Query, but that would require some M Language scripting. I personally do not recommend taking those routes which requires scripting / programming efforts, when you can do things easily with simple tricks.
@@ExcelKida thanks for the video once you free sir of possible draft m language to do automate Process
i am struggling to convert multiple PDF ages into excel. After converting into excel data goes to different columns. Do you have any suggestion or option to apply in power query.
I would say, Power Query is able to decode the tabular structures, which are fairly simply, but not expert at decoding complex structures. So, if you find any professional dedicated PDF to Excel software, go for it. In that scenario, Power Query can always assist you post converting to clean up the data & remove extra rows
@@ExcelKida Thank you for the suggestion
CONTEC NO PROVIDE
???
V Good, mai screenshot leke rakh leta hu, ki kabhi kaam ayega, but office 365 nhi hai to jab galary me screen shot milta hai to office me kaam nhi aata, abhi pta chal gya ki 365 lagega, to specially likh diya sath, me 👍
You can use web based Office 365 Excel, which is free.
Brother invoice image to tally data transfer PE vedio banaye
Already software available है उसके लिये market मे
@@ExcelKida
Please send me link vedio
@@ExcelKida bro aap vedio create kijiye
Sir plzzz formula likhe do na appka screen nhi deek ra hai barabar
CZcams ने pause button उसी के लिये दी है
Kindly use pause button of CZcams and then you can take your own time to write formula
FB link
Didn't get your comment
Do you mean you want a Facebook link?
sIR, i AM PUTTING THIS FORMULA =XLOOKUP(H2,H:H,I:I) AND THE NAME ERROR IS COMING.#NAME?
That means you are using incompatible version of Excel. You need to use office 365 version of Excel
Thanku@@ExcelKida