Count columns based on creation date and resolved date in the same table

If you are able to write custom SQL (meaning your data source is something other than an excel/csv file) you can also achieve the same thing as the UNPIVOT using an UNION in SQL. Prob an easier/more direct way of getting your data in the shape needed. Would look something like this:

SELECT
ID as ID,
Create Date as Date,
"Create Date" as Type
FROM YourTable

UNION ALL

ID as ID,
Resolved Date as Date,
"Resolved Date" as Type
FROM YourTable