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):
And we need to group by origin and hour, concatenating results:![]()
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
I'm looking for a way to do this in this Excel, with formulas.![]()
10 11 BCN MAD, CDG NYC, LHR CDG MAD, BCN NYC, LHR
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.











LinkBack URL
About LinkBacks
Register To Reply

Bookmarks