Excel Combining Text
Posted on 2014-02-21
Believe this is an easy question, but just cant figure it out. Simplified, by spreadsheet has two basic fields; an identifier (A, B, C etc) and a text remarks field. What I want to do is combine all of the A's remarks, all of the B's remarks etc.
Understand I could manually do this using transpose for each group, but since it is a very long list, I was hoping for an easier way. Thanks!
A Remark2 A Remark1 Remark2 Remark3
A Remark3 to B Remark4 Remark5
B Remark4 C Remark6 Remark7 Remark8 Remark9