Hi Guys, I've been given access to a Google Docs spreadsheet and I'm trying to build a concatenated string of values based off of cell values.

Example:


A B C D E F
1 Percent Name Missed Total Milestone StartDate
2 100 Able 0 80 80 days 11/22/17
3 94.94 Baker 4 80 80 days 11/22/17
4 100 Charlie 0 79 11/23/17
5 100 Dog 0 64 12/8/17
6 100 Eagle 0 63 9 weeks 12/9/17
7 100 Foxtrot 0 56 8 weeks 12/16/17

What I would like to do is go through the range of data and if column E is not blank concatenate the name and the info in column E and add a line break. So the data above data would create a cell like:


A
25 Able - 80 days
Baker - 80 days
Eagle - 9 weeks
FoxTrot - 8 weeks

I know I could use a bunch of nested if() but the amount of entries are not always the same, so give a range of A2:F24 There could be any number of entries in that range.

Any help is appreciated, I've looked into the various LOOKUP() and Concatenate() but haven't wrapped my head around a solution.