Display Horizontally

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?
 
D

Dave

Yeah, I've wondered about this before. We need CONCATONATEIF that works like
SUMIF. Anyone got one?
Dave
 
Top