I have built a milestone chart in excel (see attached) which consists of projects down the left, months across the top and text in cells under some months, but most cells are blank.
I would like to extract all the text from the cells and put it into a vertical list next to the appropraite projects.
Please refer to the attached sheet for details.
Any ideas how to do this?
Milestone chart example.xlsx