Taking 9 columns and making them vertical with other data

[jackson1990]

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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Project Name
[/TD]
[TD]Milestone1[/TD]
[TD]Milestone2[/TD]
[TD]Milestone3[/TD]
[TD]Milestone4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Test1[/TD]
[TD]7/3/2018[/TD]
[TD]7/20/2018[/TD]
[TD]7/28/2018[/TD]
[TD]8/4/2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Test2[/TD]
[TD]1/1/2018[/TD]
[TD]1/6/2018[/TD]
[TD]1/20/2018[/TD]
[TD]1/25/2018[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Test3[/TD]
[TD]4/12/2018[/TD]
[TD]4/18/2018[/TD]
[TD]4/23/2018[/TD]
[TD]4/25/2018[/TD]
[/TR]
</tbody>[/TABLE]

How I want it to transform
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Project Name[/TD]
[TD]Milestone #[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Test1[/TD]
[TD]1
[/TD]
[TD]7/3/2018
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Test1[/TD]
[TD]2[/TD]
[TD]7/20/2018[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Test1[/TD]
[TD]3[/TD]
[TD]7/28/2018[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Test1[/TD]
[TD]4[/TD]
[TD]8/4/2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Test2[/TD]
[TD]1[/TD]
[TD]1/1/2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Test2[/TD]
[TD]2[/TD]
[TD]1/6/2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Test2[/TD]
[TD]3[/TD]
[TD]1/20/2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Test2[/TD]
[TD]4[/TD]
[TD]1/25/2018[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Test3[/TD]
[TD]1[/TD]
[TD]4/12/2018[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Test3[/TD]
[TD]2[/TD]
[TD]4/18/2018[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Test3[/TD]
[TD]3[/TD]
[TD]4/23/2018[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Test3[/TD]
[TD]4[/TD]
[TD]4/25/2018[/TD]
[/TR]
</tbody>[/TABLE]

Is this even possible?

Thanks for your help everyone!

 

[jackson1990]

Ended up going with VBA just for compatibility. Thanks for everyone's input and help!