Forum

This does not look like a PQ issue but rather a VBA type solution. I will be looking into writing some VBA code later today to address this. It ma...

Suggest you upload a sample of your data that is representative of your actual data. In this manner we can work with what you have and not Digalo's d...

I would do this with a parameter query as shown in the attached. Create a new table of key words. Insert a column and filter for the key word with a...

You need to preface the countifs function in VBA with Application.WorksheetFunction See this link for further understanding.

I created a Parameter Query in the attached file with Power Query. You select in the drop downs the country and the OEM you want and it populates whe...

I prefer simple Bar Charts as they are easy to understand

My apologies. I missed changing your lookup word to my field name when I copied and pasted for testing. Thank you for your help and pointing out my ...

Thought we might be onto something there. However, that returns a List and when expanded shows only the letters oie for each record. The data being ...

Hi, Your request is too vague to be able to offer you a solution. Could you please upload a sample worksheet that you are having issues with, and ...

This op has crossposted this request at and and

Suggest you upload sample worksheets with tables so that we can test and analyze and offer solution.

An issue I have with your layout is that you have two header rows. If you change your header rows to Jan 03 FOB US and Jan 03 Net kg, etc for eac...

join all monthly FOB US columns together and all monthly Net Kg together? Show us what you mean by this statement. An example for just one ...

Looked at your submission, but am unable to determine where the data validation is located. You have many columns of data. Please be more specific i...