You are performing feature engineering on a dataset. You need to add a new feature and populate its column values.
Recommendation: Use the Group Categorical Values module in Azure Machine Learning Studio.
Does this recommendation meet the requirement?