Thread: How to combine multiple rows of text cells into one cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dallman Ross Dallman Ross is offline
external usenet poster
  
Posts: 390
Default How to combine multiple rows of text cells into one cell
In . com,
spake thusly:

For all records wherein I have value of Ai = "Y", I wish to have a
comma separated list of all values in Cell Bi

I think this is best done with the aid of a helper-column (which
you could hide, if you want). E.g., in New Column E, assuming
data starts on Row 2:

=IF(A2="Y",IF(ROW()2,E1&","&B2,B2),E1)

Drag that down the column. At the bottom of the helper column
is your full list of comma-separated values.

--
dman
Reply With QuoteReply With Quote