Is this possible with Google Spreadsheet

[CharlieMay]

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.

[CK76]

Try following.

Please Login or Register  to view this content.

[CharlieMay]

This is absolutely perfect. I will definitely read up on this ArrayFormula as this is something new. I don't do a lot of crazy stuff with Excel/Spreadsheets but I do like to use them to my advantage.

Thanks for your help with this.

[CK76]

You are welcome If this solved your query, please mark the thread as solved by using thread tool found at top right of your initial post.