Dates as columns?

Occasional Visitor

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 Replies
Use count ifs to summarize number of tasks in date. Then use Transpose feature in Excel to get your table the way you want.


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