Hi all,
I'm using an Excel 2008 for Mac (at work) and we need to do the following.
We have this list (much longer):
Origin Dest Hour
BCN MAD 10
BCN CDG 10
BCN NYC 11
BCN LHR 11
CDG MAD 10
CDG BCN 10
CDG NYC 11
CDG LHR 11
And we need to group by origin and hour, concatenating results:
10 11
BCN MAD, CDG NYC, LHR
CDG MAD, BCN NYC, LHR
I'm looking for a way to do this in this Excel, with formulas.
I've seen answers using user defined functions with VB or Kutools, that I can't use in the Mac.
Any help will be much appreciated.
Thank you in advance.
Bookmarks