jackson1990
Board Regular
- Joined
- Feb 21, 2017
- Messages
- 56
Hey everyone,
I was working on a project in excel where I have 9 columns of dates. They each column represent a milestone in a project (it's kind of a scheduler). I want to make a pivot table that makes it so I can see all the milestone dates. Currently this is impossible as they are in 9 columns, and in a pivot table that means they can't all be shown in an organized manner. So what I wanted to do is make all of the dates vertical in one column, but I also need to pull in the data from other columns to match it. So here is a simple example (did less milestones) of how it is currently and how I want it to go, if it is even possible to automatically? As I have a large set of data.
Currently:
<tbody>
</tbody>
How I want it to transform
<tbody>
</tbody>
Is this even possible?
Thanks for your help everyone!
I was working on a project in excel where I have 9 columns of dates. They each column represent a milestone in a project (it's kind of a scheduler). I want to make a pivot table that makes it so I can see all the milestone dates. Currently this is impossible as they are in 9 columns, and in a pivot table that means they can't all be shown in an organized manner. So what I wanted to do is make all of the dates vertical in one column, but I also need to pull in the data from other columns to match it. So here is a simple example (did less milestones) of how it is currently and how I want it to go, if it is even possible to automatically? As I have a large set of data.
Currently:
ID | Project Name | Milestone1 | Milestone2 | Milestone3 | Milestone4 |
1 | Test1 | 7/3/2018 | 7/20/2018 | 7/28/2018 | 8/4/2018 |
2 | Test2 | 1/1/2018 | 1/6/2018 | 1/20/2018 | 1/25/2018 |
3 | Test3 | 4/12/2018 | 4/18/2018 | 4/23/2018 | 4/25/2018 |
<tbody>
</tbody>
How I want it to transform
ID | Project Name | Milestone # | Date |
1 | Test1 | 1 | 7/3/2018 |
1 | Test1 | 2 | 7/20/2018 |
1 | Test1 | 3 | 7/28/2018 |
1 | Test1 | 4 | 8/4/2018 |
2 | Test2 | 1 | 1/1/2018 |
2 | Test2 | 2 | 1/6/2018 |
2 | Test2 | 3 | 1/20/2018 |
2 | Test2 | 4 | 1/25/2018 |
3 | Test3 | 1 | 4/12/2018 |
3 | Test3 | 2 | 4/18/2018 |
3 | Test3 | 3 | 4/23/2018 |
3 | Test3 | 4 | 4/25/2018 |
<tbody>
</tbody>
Is this even possible?
Thanks for your help everyone!