Wednesday, September 20, 2017

yogi_Rearrange Data In Table A:C For Unique Names Letters And Numbers

Google Spreadsheet   Post  #2245

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-19-2017
question by: jonesnca
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/KHDf_QlmbeA;context-place=forum/docs
How do I group/summarize this data in Google Sheets?
Let's say I have this data in a spreadsheet

+-------+---------+--------+
| Name  | Letters | Number |
+-------+---------+--------+
| Bob   | a,b,c   | 1,2,3  |
+-------+---------+--------+
| Bob   | d       | 4      |
+-------+---------+--------+
| Bob   | b,c     | 3,5    |
+-------+---------+--------+
| Alice | e       | 5      |
+-------+---------+--------+

How do I write a formula that displays this data like this?

+-------+---------+-----------+
| Name  | Letters | Number    |
+-------+---------+-----------+
| Bob   | a,b,c,d | 1,2,3,4,5 |
+-------+---------+-----------+
| Alice | e       | 5         |
+-------+---------+-----------+