Forum Discussion
Merge/Combine rows
I would like to combine several rows having same Key index like below. ID will be a unique ID of a product. Table 'weird' ID Category Cate_Value Size Color Price A Size 100 100 nu...
Hi , HYirang
You don't need to added 3 custom columns for each Category.
Just select the column "Category" and use the function pivot column
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.