Forum Discussion
Task Names Separate lines for Same Project
Great. Thanks for the data.
Does the ProjectName have typos? (additional upper case and lower case d on some names - i edited them)
I created a matrix visual (with ProjectName in rows, TaskName in Columns, First Startdate in Values).
I used the filter pane to filter TaskName to Task A, B, C, D.
and this is what I got
Hi,
Sorry but I can't post the data because one there is data that I can't share outside of the organization and since I can't access the source I can't delete the sensitive data.
The desired outcome is this:
| Project Name | Task A | Task B | Task C | Task D |
| 12345 | Date1 | Date2 | Date3 | Date4 |
| 67890 | Date5 | Date6 | Date7 | Date8 |
| 25468 | Date9 | Date10 |
I want all of the tasks that correspond with the same project Name to go on the same row, but currently they are creating a new row for each task. Not every task will have a date for each project, but there is a possibility of it.
I don't want to see the real data. I want to see some sample data that shows what the table (or tables) looks like. Mock something up in the same way you've done with the desired outcome.