Last seen: Apr 30, 2025
Can you supply a dummy file that is representative of your issue so that we can work with your data types.
Post your entire Mcode for analysis.
Nesha Your picture is exactly what I get when I wish to import your PDF. Click on the Select multiple tables and then select them. This will gen th...
Rory Modified Mcode worked perfectly Alan
Rory, When I tried your Mcode, it errored looking for the Index Column that you created in the Group By. I separated those steps and this worked f...
There are 76 tables in this file. Do you know which ones you want?
1. Once imported to PQE, replace all null with zero 2. Set the data type for the columns in question to whole numbers 3. Add the columns (in a ne...
Pictures are really nice, but cannot manipulate data in them. Suggest you upload a sample file that we can work with. Don't ask us to recreate your ...
unable to assist. File is locked as read only and cannot change on my side. Macro will not run as it is blocked by security on your end. Sorry. Go...
Rather than have us reenter all your data into a spreadsheet, instead of a picture, please upload your file so that we can manipulate the data. Help ...
Attached file is unreadable. Please try again.
A sample workbook uploaded showing your current data and then indicating where you wish to place your results and what fields/cells you wish to track....
Maybe this: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Admin rate/Bas...
Does this look like what you are expecting. You did not give us a mocked up solution so I am guessing Name ...
In my mind the best method would be a date time field that indicates the updates. Then the latest record can be maintained and any earlier records rem...