Merging multiple header row contents into one cell
I am working on an Excel table that has an account header row and details rows of codes under that account. Each account can have a different number of codes. I want to be able to merge all the codes into a single cell separated by comma next the corresponding account number without having to do it manually for each account. I am using the concatenate function as shown above. Is there a Macro I can develop to do this automatically?
Help. I am stumped.
emmorel
|