Hi folks,
I have the following in Sheet1
Data 1 Data 2
A Alpha
A Beta
A Charlie
B Delta
B Echo
And this in Sheet2
Data 1 Result
A Alpha-Beta-Charlie
A Alpha-Beta-Charlie
A Alpha-Beta-Charlie
B Delta-Echo
B Delta-Echo
Columns As in both sheet are identical and I'd like to concatenate as shows in result column of 2nd sheet.
Thanks
Khan
Bookmarks