sanilmathews
Board Regular
- Joined
- Jun 28, 2011
- Messages
- 102
Hello,
I am in need of a code which would below requirements:
Sheet1 Column A will have list of names and Column_B will have set of 32 line tems. I would require the code to generate below process in Sheet 2 Column A (all information in a single column).
Process:
to concatenate first item in Sheet1 Column A with the list of 32 line items in Sheet1 Column B. Similarly second item in Column A concatenates with the list of 32 line items in Column B. This should loop till last item in Column A.
Thanks in advance!
I am in need of a code which would below requirements:
Sheet1 Column A will have list of names and Column_B will have set of 32 line tems. I would require the code to generate below process in Sheet 2 Column A (all information in a single column).
Process:
to concatenate first item in Sheet1 Column A with the list of 32 line items in Sheet1 Column B. Similarly second item in Column A concatenates with the list of 32 line items in Column B. This should loop till last item in Column A.
Thanks in advance!