Here i need help in data transformation so i will brief my requirement as below.
In this activity, i need to combine multiple rows of data into a single row based on a shared identifier (such as a customer_id) and concatenating the values from these rows into a single column separated by a comma.
Here is my data :
In this data product_name has multiple rows.
And I want data like product_names row should have only one row with mutliple values as comma separated values for each customer_id.
Please try to help me to achieve this requirement.