R
ryguy7272
Hello everyone! I have data in Columns A to G. I have a list of names in
Column B. If the names are arranged in descending order (so similar names
appear in above or below cells). If two names are the same, I'd like to take
the data in Column C, and combine the records, separated just by the pipe
character '|'. If the names in Column B are the same, all data in Column A,
as well as d to G will be the same. Only differences are in Column C. For
instance:
Before:
Column A Column B Column C Column D Column E Column F Column G
(e-mail address removed) Ryan 142726 1/6/2009 ChiChi CA 94133
(e-mail address removed) Ryan 142767 1/6/2009 ChiChi CA 94133
(e-mail address removed) Ryan 142792 1/6/2009 ChiChi CA 94133
After:
Column A Column B Column C Column D Column E Column F Column G
(e-mail address removed) Ryan 142726 | 142767 | 142792 1/6/2009 ChiChi CA
94133
How can it be done?
Thanks,
Ryan---
Column B. If the names are arranged in descending order (so similar names
appear in above or below cells). If two names are the same, I'd like to take
the data in Column C, and combine the records, separated just by the pipe
character '|'. If the names in Column B are the same, all data in Column A,
as well as d to G will be the same. Only differences are in Column C. For
instance:
Before:
Column A Column B Column C Column D Column E Column F Column G
(e-mail address removed) Ryan 142726 1/6/2009 ChiChi CA 94133
(e-mail address removed) Ryan 142767 1/6/2009 ChiChi CA 94133
(e-mail address removed) Ryan 142792 1/6/2009 ChiChi CA 94133
After:
Column A Column B Column C Column D Column E Column F Column G
(e-mail address removed) Ryan 142726 | 142767 | 142792 1/6/2009 ChiChi CA
94133
How can it be done?
Thanks,
Ryan---