Date rows as columns

[Anonymous]

Hi everyone,

I have a table with 2 different date columns: "as of date", "prod. date". It also contains a first column with multiple clients and columns for different types of products, as shown in the screenshot.

How can I create a separate table filtering for Type 1,  where the dates in column "as of date" appears as column headers, after the column 3: "prod. dates"  e.g. 10/29/2019 .. 10/30/2019.. 10/31/2019.. having hundreds columns of dates?

Thanks,