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.
Bookmarks