Concatenate if

**nirola** · 02-10-2010, 04:00 AM

Hi,

I have product codes on column A where in they are repeated upto 25 times in that same column and i have name of the city along with quantity dispatched in single cell on column B

My requirement is if the same product code is issued to n numbers of citites than all the value of column B should CONCATENATE in cell C

E.g if procuct is issued 6 times (column a) to one or more than one cities (Column B) then c1 cell should have values of all the cities or city as per column B in c1 and so on for all teh products.

Thanks

**ratcat** · 02-10-2010, 04:28 AM

G'day

Could you supply (upload) a before and after results you wish to happen so my tiny little brain can understand you example.

Thanks

**nirola** · 02-11-2010, 03:06 AM

see attached

**ratcat** · 02-12-2010, 06:10 AM

Originally Posted by nirola

.........E.g if procuct is issued 6 times (column a) to one or more than one cities (Column B) then c1 cell should have values of all the cities or city as per column B in c1 and so on for all teh products.....

I'm still at a lost here too that comment above to matching the before and after results found on the sample sheet that you attached.

But in saying that I believe that I may have solved the challenge but I'll let you to be the judge of that

See attachment.......