Evening all,
I have a number of workbooks where I would like to consolidate data from the same defined cell references from each document to form one dataset (a three column table). The attached workbook shows which cells I would like to retrieve data from across the 'Supplier' and 'Status' tabs (Blue cells are the header and yellow the data).
I've also added a tab with the expected output.
If you have any queries just give me a shout.
Thanks in advance,
Snook
Last edited by AliGW; 11-08-2021 at 06:18 PM. Reason: Moved to mire suitable forum section.
This tutorial should guide you to what you have requested.
https://www.youtube.com/watch?v=OFt9b6DgvY0
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Nice one Alan, much appreciated.
It took me a while to crack but I got there. The final hurdle I needed to navigate was an error when I tried to pivot the data. The error message stated 'Expression.Error: There were too many elements in the enumeration to complete the operation.' For anyone who encounters a similar problem this solution worked for me. Link
I'm still trying to learn Power Query but I'm really impressed with what I've been able to achieve so far. The functionality could be a game changer for my role.
Snook
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks