Hi all

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?

Many thanks








Milestone chart example.xlsx