P patelpina New Member Feb 18, 2013 #1 I have this in excel: [pre] Code: Number Letter Description 1 A one 1 B one 1 C one 2 A two 2 D two I need the result to be: Number Letter Description 1 A, B, C one 2 A, D two [/pre]
I have this in excel: [pre] Code: Number Letter Description 1 A one 1 B one 1 C one 2 A two 2 D two I need the result to be: Number Letter Description 1 A, B, C one 2 A, D two [/pre]
J jason Member Feb 18, 2013 #2 how many letters (A, B, C) could there be? now many numbers (one, two, etc)?? do you want the result to be all in one cell or in diff. columns in the same row?
how many letters (A, B, C) could there be? now many numbers (one, two, etc)?? do you want the result to be all in one cell or in diff. columns in the same row?
Luke M Excel Ninja Staff member Feb 18, 2013 #3 Perhaps this similar thread will be helpful. http://chandoo.org/forums/topic/getting-a-concatenated-text-list-of-applicable-values
Perhaps this similar thread will be helpful. http://chandoo.org/forums/topic/getting-a-concatenated-text-list-of-applicable-values
P patelpina New Member Feb 18, 2013 #4 i want the result to be in one cell cell For example: There are 3 columns so i want three columns but merging data with comma in the same cell.
i want the result to be in one cell cell For example: There are 3 columns so i want three columns but merging data with comma in the same cell.
