Last seen: May 28, 2025
Would be very helpful if you attached (uploaded) a sample file with 8-10 records showing what your file looks like when it has been downloaded from th...
With your table let Source = Excel.CurrentWorkbook(){[Name="Tbl_1"]}[Content], #"Filtered Rows" = Table.SelectRows(Source, each [Employee...
crossposted: Please read-->
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 ...