Please forgive me if this is duplicated - my first time using these forums.
I need to either create a CONCATENATE formula or a VBA to accomplish what is in this picture.Exel Concatenate.JPG

Thank you!