Last seen: Aug 3, 2025
crossposted: Please read:
Using just native Excel features, you could select filter on the Data Tab and unselect blanks.
Suggest you upload a sample file showing your source values and a mocked up solution so we have a solid idea of your needs. Do not upload a picture a...
If your data is in its final presentation mode and you do not need to maintain formulas in the output, then I would recommend using Power Query to rea...
Deidre Taking another approach, please attach a sample excel sheet and a sample access workbook showing your issue. Tell us exactly how you take t...
maybe attached
Look at this link for tutorial
The link provided takes me on the internet to "Page Not Found" In any event, you can bring a PDF file into Power Query also called Get and Tra...
A Workbook would be very handy. I am guessing that your data should be normalized by unpivoting your table and doing a Group By on the products to fi...
1. With Power Query or Get and Transform Data depending on what version of excel you have, load your data to the PQ editor. 2. Group your query o...
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = Table.Group(Source, {"License plate no"}, {{"Latest Closed Date", ea...
Lea If you normalize your data as I have done in the attached by unpivotting the data, then you can apply Excel formulas like Sumifs or pivot your ...
emails are not the way. It does not allow for all in the forum to understand the issue. Attach a file to this forum. Click on the link below to att...
Trying to understand what you want the end result for the data in the two tables to look like. Can you please supply a mocked up version for the data...
Provide us with a file of sample data 15 records or so and then mock up what you want the result to look like for the records provided. It will make ...