dserradas
06-22-2012, 09:03 AM
Hi Guys,
I am looking for code that concatenates data in sheet1 and places it into sheet2. The values need to be separated by a ^. Column A in sheet 1 should always be the prefix for the row. When the entire row has been concatenated, the script should jump down to the second row and continue.
My sample file shows how the data should be formatted.
I've searched through old posts for a solution but cannot find anything that matches. Any help would be appreciated!
I am looking for code that concatenates data in sheet1 and places it into sheet2. The values need to be separated by a ^. Column A in sheet 1 should always be the prefix for the row. When the entire row has been concatenated, the script should jump down to the second row and continue.
My sample file shows how the data should be formatted.
I've searched through old posts for a solution but cannot find anything that matches. Any help would be appreciated!