Last seen: Jun 2, 2025
Another means is to create a column that is the month number. Then Group By the Month for a Max Date Duplicate that query and remove the last step ...
Mcode let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = Table.Group(Source, {"Attribute"}, {{"Data", each _, type t...
No file attached. Please try again.
file attached once more.
Is this the type of presentation you are looking for? If so, it is a merge (join) in PQ and not an append File attached
A picture is worth a thousand words. A file attachment is worth a thousand pictures. Attach a file showing what you have (8-10 records only) and a m...
Pictures are kind of useless and do not allow us to manipulate data. Suggest you upload a workbook that can be manipulated and tested with a workable...
crossposted: Please read:
Pictures are pretty much useless. We cannot manipulate the data in a picture and to be honest, no one really wants to try and recreate your worksheet...
A couple of issues with your data. One is all caps while the other is initial caps. These are not matches. Additionally, once I capitalize all ther...
Maybe this VBA will help you? Sub ListAllFile() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim ws As Worksheet Dim sPath...
How about uploading a sample file of 10-15 records showing a representative sample of what you have. Then show us a mocked up solution of what you wa...
Build your first query. In the left window, click on duplicate. Then change the source in the second query. Repeat for each query.
Here is a Power Query Solution let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Split Column by Delimiter" = Table.SplitColumn(Tab...
With Power Query, I have done a full outer join of the two files. Not exactly sure what you are looking for here but this may be helpful