I have a spreadsheet containing data in Columns say A - O. Column A contains a list of values, Columns B - O contains lists of values which correspond to the list in column A. I am looking for a way (either formula or macro) to concatenate all these values into a separate column (Q). All columns contain headers, so the values begin in row 2. There are a different number of values for each column (B - O).
Please let me know if any questions to clarify my request.
Regards,
Doug
- So, the first value in column A will need to be concatenated with a "/" delimiter to all the values in column B, the result posted in column Q beginning on row 2
- Then, the second value in column A will need to be concatenated with a "/" delimiter to all the values in column C, these results posted in column Q beginning on next blank row (after the results from the first concatenation)
- Then, continue this pattern until all the values in column A have been concatenated with a "/" delimiter to all the corresponding values in columns D - O and the results a single list in column Q
Please let me know if any questions to clarify my request.
Regards,
Doug