Forum Discussion
Extracting and Appending Data in Power Query
The report I am working on includes daily transactions, each preceded by a summary box. Part of the summary box, contains data on the deposit date. My challenge is extracting this deposit date from the summary box to append as a new column in the corresponding daily transaction list below.
The challenge is compounded by the fact that the deposit date in the summary box shares a column with transaction details. The report layout is sequential; as you scroll down, you encounter new transaction dates followed by another summary box, each containing a new deposit date. This pattern repeats throughout the document.
Despite efforts, I am struggling to figure this one out on Power Query to accurately isolate and position the deposit date. If anyone has experience or insights on how to streamline this process, I would greatly appreciate anyone's help.
Please share an anonymised file that shows the exact launch-out of the file. Provide a link that gives unrestricted access to it on OneDrive, Dropbox or similar. Otherwise it will be difficult to help.
- Riny_van_Eekelen
Here's the link to the file: https://1drv.ms/x/s!AjWBufGkLFQR0VwZrUuGqA2a05_D?e=Izehjd
If you can't access, let me know please.
Thanks in advance!rishan_nagarajan Please see if the attached file contains the solution you had in mind. It's pretty straight-forward. Come back here if you get stuck.
