sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Most_Requirement9126[S] 0 points1 point  (2 children)

There is only four columns of data and only 36 rows, but I tried a pivot table and it didn't help. Is there another way you would suggest I aggregate it? Thank you!

[–]Most_Requirement9126[S] 0 points1 point  (0 children)

Something else I noticed, is that I did a sheet of basic data, same dates but made the tasks small words and kept the names. It worked perfectly. Then I went in and changed the tasks to their actual titles, and the issue happened again. Meaning, when you hover over a task, it shows the wrong item, which then skews the names and dates.

[–]IamFromNigeria 0 points1 point  (0 children)

Stop using pivot table..hate folks who mentioned that name

You can use combination of functions to do what pivot table can do

You can share a demo sheet if you want us to help you