Last seen: Jun 25, 2026
@bee Glad I could help!
@solomon-mutibwa OK, I had a closer look at the PDF tables. Tables 1,2,5,9,11,12 and 13 include an extra column (11) with only "WILLY" in the header...
@ericj I believe the pt in the attached file gives you the correct result. Though you might want to hide some columns since you only want the YTD % ...
@bee Hi! Used your latest file and got rid of most of the data as the file is quite big. Added some entries in the first tab (in the Week table and...
@solomon-mutibwa No need to connect and load all tables and then transform each one separately. I'd suggest you connect to all relevant tables and ...
@besa83 Glad I could help.
@besa83 To keep it fairly straightforward I would create on table as shown in the attached file in Sheet1. It has two time columns. One for the entr...
@adeleo Can't do much without the file. Can you upload it? Remove any confidential information if needed but leave the structure as so that the errors...
@ld107 You're welcome!
@ld107 Well, I would probably use Power Query (PQ) to combine all the data. Though I'm not sure as I haven't seen all your file(s). But you menti...
@ld107 Great and good luck. Just post again when you get stuck. PS: "52 worksheets" as in one for every week?
@susanne Without seeing your file or knowing exactly what you are dealing with, I would create one file for each sales area. All looking the same an...
@adeleo Please elaborate. Where/when does this issue occur?
@ld107 Not sure I understand your question. If you already have a "Sheet1" with all your real assets, just copy them asset-by-asset into the table ...
@ld107 Hi Lee, Please see attached. I've added as sheet to show how I would set-up the data table and find the duplicates. First I copied the 5...