I need to put together multiple entries into one where the results is text and has to be in one cell.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
There is an excellent precedent on StackOverflow for this question - though I can't locate it just as the moment. This solution is based on How to do a "group concat" in an ARRAYFORMULA? in the Google support form.
Let's assume that your raw data is in Columns A and B, and the output will be in Columns C and D.
Insert this formula in Cell C1.
BEFORE - raw data
AFTER - additional data