| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Please help me.
Hello,
My original worksheet is like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH BEQAB HAMILTON BEACH BEQAB 00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|REGAL BEQBBP K7001NF|REGAL I want to get a worksheet like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH|00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|K7001NF|REGAL I cannot figure our how to get it. Please help me. Thank you very much! Best regards, -- George |
|
#2
|
|||
|
|||
|
Copy and paste and cut and paste, the layout is not the best I have seen
honestly, do you intend to have for instance HAMILTON BEACH|00756|VITA MIX in one cell? This would require lots of manual labour, I would probably use autofilter and filter on the categories and then copy and paste -- Regards, Peo Sjoblom -- Regards, Peo Sjoblom "smb2000user100" wrote in message ... Hello, My original worksheet is like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH BEQAB HAMILTON BEACH BEQAB 00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|REGAL BEQBBP K7001NF|REGAL I want to get a worksheet like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH|00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|K7001NF|REGAL I cannot figure our how to get it. Please help me. Thank you very much! Best regards, -- George |
|
#3
|
|||
|
|||
|
Hi
a similar question was asked in microsoft.public.excel.programming yesterday .... my answer then was ..... use the advanced filter to generate a list of the unique ID numbers in another column on your worksheet (Debra Dalgleish has notes on how to do this at www.contextures.com/tiptech.html) and then use a UDF that Harald Staff and myself created called CONCAT_IF to concatenate the keywords ... this function and notes on using it can be found at my website www.hcts.net.au/tipsandtricks.html the OP of that question replied that the answer had worked well for him, so maybe it will also work for you -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "smb2000user100" wrote in message ... Hello, My original worksheet is like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH BEQAB HAMILTON BEACH BEQAB 00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|REGAL BEQBBP K7001NF|REGAL I want to get a worksheet like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH|00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|K7001NF|REGAL I cannot figure our how to get it. Please help me. Thank you very much! Best regards, -- George |
|
#4
|
|||
|
|||
|
Thank you very much! I will try the solution you told me.
"JulieD" wrote: Hi a similar question was asked in microsoft.public.excel.programming yesterday .... my answer then was ..... use the advanced filter to generate a list of the unique ID numbers in another column on your worksheet (Debra Dalgleish has notes on how to do this at www.contextures.com/tiptech.html) and then use a UDF that Harald Staff and myself created called CONCAT_IF to concatenate the keywords ... this function and notes on using it can be found at my website www.hcts.net.au/tipsandtricks.html the OP of that question replied that the answer had worked well for him, so maybe it will also work for you -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "smb2000user100" wrote in message ... Hello, My original worksheet is like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH BEQAB HAMILTON BEACH BEQAB 00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|REGAL BEQBBP K7001NF|REGAL I want to get a worksheet like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH|00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|K7001NF|REGAL I cannot figure our how to get it. Please help me. Thank you very much! Best regards, -- George |
|
#5
|
|||
|
|||
|
Thank you! It works very well.
"JulieD" wrote: Hi a similar question was asked in microsoft.public.excel.programming yesterday .... my answer then was ..... use the advanced filter to generate a list of the unique ID numbers in another column on your worksheet (Debra Dalgleish has notes on how to do this at www.contextures.com/tiptech.html) and then use a UDF that Harald Staff and myself created called CONCAT_IF to concatenate the keywords ... this function and notes on using it can be found at my website www.hcts.net.au/tipsandtricks.html the OP of that question replied that the answer had worked well for him, so maybe it will also work for you -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "smb2000user100" wrote in message ... Hello, My original worksheet is like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH BEQAB HAMILTON BEACH BEQAB 00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|REGAL BEQBBP K7001NF|REGAL I want to get a worksheet like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH|00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|K7001NF|REGAL I cannot figure our how to get it. Please help me. Thank you very much! Best regards, -- George |
|
#6
|
|||
|
|||
|
|
|
#7
|
|||
|
|||
|
Hi David
thanks for spotting this, i can never remember if it is htm or html ... eek! -- Cheers JulieD "David McRitchie" wrote in message ... http://www.hcts.net.au/tipsandtricks.htm as in your signature not .html as in the body |
|
#8
|
|||
|
|||
|
you're welcome and thanks for the feedback
-- Cheers JulieD "smb2000user100" wrote in message ... Thank you! It works very well. "JulieD" wrote: Hi a similar question was asked in microsoft.public.excel.programming yesterday .... my answer then was ..... use the advanced filter to generate a list of the unique ID numbers in another column on your worksheet (Debra Dalgleish has notes on how to do this at www.contextures.com/tiptech.html) and then use a UDF that Harald Staff and myself created called CONCAT_IF to concatenate the keywords ... this function and notes on using it can be found at my website www.hcts.net.au/tipsandtricks.html the OP of that question replied that the answer had worked well for him, so maybe it will also work for you -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "smb2000user100" wrote in message ... Hello, My original worksheet is like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH BEQAB HAMILTON BEACH BEQAB 00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|REGAL BEQBBP K7001NF|REGAL I want to get a worksheet like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH|00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|K7001NF|REGAL I cannot figure our how to get it. Please help me. Thank you very much! Best regards, -- George |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
