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:

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!

 

[jackson1990]

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