Excel formula to skip a cell, multiple conditions

[mattyblueice]

Happy New Year!! I have a sheet with 3 columns filled with data and I am trying to consolidate that data vertically. For example,

Column A Column B Column C
Planning Research Testing

I want to create a formula that looks at each cell and in Column A and if there is a value than return the column header in Column A (Planning). I want this to continue for every cell in column A and if it reaches a blank, then to skip to column B and perform the same analysis, then skips to Column C, performs that same analysis and when it reaches a blank in column c then to stop.

I am not sure how to do this and would appreciate any ideas!

Thanks

Matt

 

[mattyblueice]

Wow that was "easy" lol Thanks - never heard of this formula

 

[Fluff]

You're welcome & thanks for the feedback.