Hi folks,
I am a newbie here in the Excel Forum but not completely new to Excel. I have a challenge with concatenating multiple columns and inserting semicolons and spaces.
The top of my sheet has fields to enter date, product, style etc. These I have been able to concatenate into a string with no problem. Part way down the page I have a couple of columns that the user needs to enter product sku numbers and descriptions. The rows are broken down into about 20 sections and not all rows will contain a sku and description. This will create empty rows in my 2 columns.
I have a row at the bottom of the screen where the concatenated string of data is displayed (it's used as metadata for images).
The challenge is to start at the top of the 2 columns and concatenate the contents until it reaches the last row in the product info section. Between the contents of each row I need to place "; " semi colon and a space. The empty rows need to be ignored.
Ahh, just realized I can add a file so I hope it helps see what I am trying to do.
Metadata sheet-updated.xls
The end result I am hoping for...
092812-transitional-mirror; transitional; living room; mirror scene; 12345 crystal chandelier; 54321 brass floor lamp; T4321 recliner; T4322 ottoman; 01234 area rug; W1234 round mirror; 98765 crystal candlesticks
Many thanks,
Limey
Bookmarks