-1

I have this kind of data (2500 rows)

 |   A  |  111  |
 |   A  |  222  |
 |   A  |  333  |
 |   B  |  444  |
 |   B  |  555  |
 |   B  |  666  |
 |   C  |  777  |
 |   C  |  888  |
 |   C  |  999  |

I would like it to merge like this, still keeping 2 columns, no separators between the data:

 |   A  |  111 222 333 |
 |   B  |  444 555 666 |
 |   C  |  777 888 999 |

Thanks for your help!

user883356
  • 33
  • 9
  • What excel are you using? – Scott Craner Aug 09 '16 at 13:52
  • 1
    What have you researched, tried, and found to not provide the desired output? – dfundako Aug 09 '16 at 13:53
  • In my experience you can't do this in formulas alone (without a 3rd party add-in). You could do it with formulas but then have the 111 222 333 in separate cells. Or you could do with with a VBA function. Choose your poison. – Tim Edwards Aug 09 '16 at 14:17
  • @pnuts I thought that too but in a previous question I tried to do that and even though the entries appeared correct in their separate cells when I tried to concatenate them it caused an error. – Tim Edwards Aug 09 '16 at 14:31
  • 1
    I didn't either! I'll try and dig it out. – Tim Edwards Aug 09 '16 at 14:35
  • see here: http://superuser.com/questions/922975/how-to-combine-values-from-multiple-rows-into-a-single-row-with-a-comma-separato – Scott Craner Aug 09 '16 at 15:17

1 Answers1

0

This is my answer to this question previously where you have answers in different columns.

This is my one from earlier today which uses a VBA function to do something similar.

Community
  • 1
  • 1
Tim Edwards
  • 1,031
  • 1
  • 13
  • 34