How to combine text values using CONCATENATE & TRANSPOSE functions Excel Trick

[Kimmy]

Thank you so so much for this tutorial! :) it's pretty close to what I needed, but now I need to copy down this formula to other groupings of text. so for instance Lets say the first three rows of data were to be concatonated together then there was a space and three more rows of data should be concatenated - there are unique values for each grouping. Should I use an =IF statement combined with Concatenate?