Forum

Why not just filter them out?

Would be very helpful if you uploaded a sample data file (no pictures please) showing your existing data and a mocked up results of what you expect.

This sounds to me that you would be better served with a Relational Data Base Management System. You could do this in MS Access and generate queries ...

No file has been attached. Think you might have missed the upload step after attaching.

If I am understanding correctly, then attach this line of code to a command button ActiveWorkbook.RefreshAll

You could save the Excel file as a PDF and then email or share on a network.

Cannot determine what your issue is. Two tables seem to have relationships and you have created a PT. What are we missing in your explanation?

How about supplying us with a sample file that we can analyze. You have not provided enough data.

I would pivot the data in Power Query let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Pivoted Column" = Table.Pivot(Table.Tr...

Look at this link for a solution to split multiple columns at once. Power Query--Split Multiple Columns at one time | MrExcel Message Board

Here is a good link to learn about PQ

As I stated in the file Alan, merely changing the number format does not help. Interesting because when I did the reformatting it came up as zero...

In the column containing the Store Name, click on the Sort drop down. Select Text filer. Select Begins with No Frill and select the Or function in t...

Right click on the value in your PT and select Format. Change the format from General to Number.

Here is the revised code let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Transposed Table" = Table.Transpose(Source), #"Filled ...