COUNTIF for Re-order Tracking

Hello,

there's a little work involved in creating a proper data table from this report.

select columns A to G in Sheet1
change the Format to "General" (all cells are currently formatted as text, which we need to change to use formulas)
select column A
hit F5 - click special - tick "Blanks" and hit enter
hit enter once to move the active cell to row 3 while keeping all the other cells selected
enter a = sign, hit the up arrow
hold down CTRL and hit enter

Now the previously blank cells in column A hold the company name.

Delete the error message in A1 and enter a title, like Customer.

Now you can create a pivot table. Pull the customer field into the rows and the item into the columns area and into the data area. Set the field to perform a count. Filter the item to show only The Connectors

see attached.