Search results

Cannot manipulate data in a picture. Upload a sample file that is representative of your issue and we will do our best to provide you with a workable solution. BTW: You will always get more responses with a descriptive title to your thread. Titles such as your often get ignored

Curious, why would you need a button to run "Refresh All? when it is native to Excel and found on the Data Tab. Seems a bit redundant to me.

More information. Details of what you are trying to do. Your request is too vague to respond. We need details. We are not mind readers.

Here are links to possible solutions https://www.excelforum.com/excel-general/596215-listing-all-combinations.html https://www.get-digital-help.com/return-all-combinations/ Note: I tested the first solution and it ran almost instantaneously. Good Job for Mike Erikson developing this.

Power Query cannot distinguish colors, but I was able to count the number of T1, T2 etc by the value in Column A. Will that work for you. here is the Mcode to do that let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Removed Other Columns" =...

Suggest you load some sample data worksheets. In this manner, we can examine what you have and have completed.

A sample workbook with 10-15 rows of data would certainly help. Then show us what you would like those 10-15 rows to look like in a PT. Can't help what we cannot see.

Problem opening file

Save as a PDF and forward as such

An alternative that does not require you do any coding

It would be helpful seeing the data. That being said, I think the problem may be that PQ cannot sort a null value. Maybe change the null to something else, ie. 3 in your if statement.

A power query solution let T1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], T2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], MQ = Table.NestedJoin(T1, {"HHS"}, T2, {"Column1"}, "T3", JoinKind.RightOuter), #"Expanded T3" = Table.ExpandTableColumn(MQ, "T3"...

Read my signature. Its there.

Used Power Query. Here is the Mcode that is in the workbook let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Transposed Table" = Table.Transpose(Source), #"Changed Type" = Table.TransformColumnTypes(#"Transposed Table",{{"Column1", type date}}), #"Transposed...

crossposted: https://www.myonlinetraininghub.com/excel-forum/excel/how-to-combine-rows-in-power-query#p31192 which has a solution.

Look at the attached and see if you can go forward from there. Not sure what exactly your results should look like as your input and output fields do not match up and my crystal ball is out for repairs.

I cannot manipulate your data. All the cells are text and will not convert to numerical data. In order to do averages, these "numbers" need to be real numbers and not text data that look like numbers.

It would be helpful if you took your data in the above post and uploaded it as a file. Currently, when I try to manipulate that data it is all text and I cannot convert it to numbers without re-typing. I do have a solution for you but I need your sample data in a file.

If I am understanding correctly, Filter on 37 and then join the two tables. I have built a parameter table where you can enter the appropriate AccountBK and then refresh the query.

When I join the two tables on the common field, I get no matches for the Account BK Here is my Mcode to join the two tables let T1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], T2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], MQ = Table.NestedJoin(T1...

Is the common field Jouranl Entry BK. Is that what we should be joining on.

It would be very helpful if you provided some sample data of 10 to 15 records for each so that we can visualize and manipulate. With the sample data, mock up what you want the solution to look like so we can replicate. Do not load pictures as we cannot manipulate data in a picture. Upload...

Show us the code with the refresh directions so that it can be analyzed.

I do not see a PBNO field and definitely no sheet called VD-Sales. So what data do you wish to extract and what do you want the result to look like. Take a few rows of your data and show us a mocked up solution. My crystal ball is out for repairs, so I have no idea what you are trying to do...

Your customer Numbers do not match up. But a simple unpivot should work. You will have an extra column when you unpivot but you can remove it before close and load.