Forum

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

The date time column is coming over as European as dd/mm/yy hh:mm AM or PM What do you want the data to look like? I can convert it to US format i...

Here is what Microsoft suggests

Highlight your table and click on Add to Data Model and click on refresh all. Same as you would in a regular Pivot Table. Make sure you are in Power...