Forum Discussion
How to copy transaction from credit card statement with the help of power query or any new method
Hi Community,
The transactions i copied from statement are pasted in one cell.
How can we split the content as per the format included in attached file with the help of power query or any other method.
Thanks and Regards
Sakshi Roy
4 Replies
SAKSHI_ROY Perhaps easier to connect to the statement itself rather than copy/paste every row into one cell. What format does the statement come in?
Riny_van_EekelenThe statement is in PDF format.
And i currently use 2016 version which do not give excess to connect with PDF under Get data Tab.
SAKSHI_ROY I see. Then it's going to be difficult as there are no consistent delimiters to separate the transactions.
