Apr 11 2022 12:18 AM
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
Apr 11 2022 02:07 AM
@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?
Apr 11 2022 04:43 AM
@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.
Apr 11 2022 04:52 AM
@SAKSHI_ROY I see. Then it's going to be difficult as there are no consistent delimiters to separate the transactions.
Apr 11 2022 05:47 AM
@Riny_van_EekelenI will look at some other trick ans share with you.
Thanks for your concern and time invested on my query.