Can anyone please help me with concatenation? I need to convert 'Original data' to 'Concatenated data'.
Original data:
a 1
b 2
c 3
Concatenated data:
a1
a2
a3
b1
b2
b3
c1
c2
c3
Can anyone please help me with concatenation? I need to convert 'Original data' to 'Concatenated data'.
Original data:
a 1
b 2
c 3
Concatenated data:
a1
a2
a3
b1
b2
b3
c1
c2
c3
Please attach a sample workbook with expected output for better understanding
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
@Sixth Sense: Hi thanks for responding, i have attached the sheet.
Not sure which data needs to be concatenated with which one
Please give some description about your data and the expected output for better understanding
Hi Sixth Sense,
In the sheet provided, I need to concatenate Name with Code and retrieve the combinations for each name and code. I am illustrating the same example provided in the sheet:
Name Code
Johnson i01
Smith i02
James i03
I need following combination for each Johnson, Smith, James in 'Name' column with each entry in 'Code' column:
Johnsoni01
Johnsoni02
Johnsoni03
Similarly i need combinations for the rest:
Smithi01
Smithi02
Smithi03
Jamesi01
Jamesi02
Jamesi03
I hope this is clear. Let me know if you need further clarifications.
Sorry I have seen some other file and requested you for a brief.
Try this code....
Please Login or Register to view this content.
Thank you so much Sixth Sense! Worked like a charm.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks