How to copy transaction from credit card statement with the help of power query or any new method

Occasional Contributor

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.

@Riny_van_EekelenI will look at some other trick ans share with you.

Thanks for your concern and time invested on my query.