I am dealing with unstructured data. I am particularly interested in clubbing values of 2-3 rows of a primary key column into one. For instance,
Column name: Industry
Pharmaceuticals & Biotechnology
I wish to club these 4 rows into 1 and aggregate the numerical values, if any, for each related column. Is there any way to do it in exploratory?