Display Horizontally

  • Thread starter Thread starter Dr DR
  • Start date Start date
D

Dr DR

I have data in the following format:

Code Time
2 2.4
2 4.6
2 10
5 2.1
5 10

I would like to display it by Code in one time cell. For example,
Code Time
2 2.4,4.6,10
5 2.1,10

etc...

Is this possible to do without writing a VB script?
 
Yeah, I've wondered about this before. We need CONCATONATEIF that works like
SUMIF. Anyone got one?
Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top