Dates as columns?

[pspaans]

We have a large dataset of tasks (in rows) with 3 colums with dates (start, end, projected) amongst some other info in colums. Now they want to see per date (as column headers) what task there is.

I've struggled how to create this, the only thing I could come up with is a slicer / timeline. 

Any other more elegant solutions?

[#2]

Use count ifs to summarize number of tasks in date. Then use Transpose feature in Excel to get your table the way you want.

[#3]

@pspaans 

Perhaps PivotTable works, but that's better to discuss having the sample - what is input and what is desired output.