Pivot table date Format Mismatch - Pls.Help

I looked at the data. All the dates for Tool 1 are in March 2019. All the dates for Tool 2 are in February 2019. There is no overlap in the dates and the pivot table is working as it should.

The reason for the split is with the source data. The data associated with Tool1 are numbers. The data associated with Tool2 are strings. You have to change them to the same type.

I chose to change them into strings. I added a helper column in Column G with the formula, =B2&"", Concatenating a null string to a number forces it to be a string,. Concatenating the null string to a string does nothing; it leaves it unchanged.

I could have copied -> paste values only the results back into column B. Instead I chose to extend the data source of the pivot table to include Column G and use that as the column headers.

Now that I think about it, there was an easier way. I could have chosen to convert all to numbers instead of strings. I can do this without the use of a helper column.

Type the digit 1 into an unused cell. Then select it and copy it. Select the range containing the original dates. Select Paste -> Special and click the box for Multiply. This action multiplies the range being pasted into by the copied value. Multiplying a number by 1 does not change it. "multiplying" a string by 1 converts it into its numerical equivalent. Then all you have to do is refresh the pivot table.