A naukri.com initiative
Dev
3w
101
Image Credit: Dev
#137 — Re-group or Sort When Filling Grouped Data into Columns
- A data table contains products with multiple colors for the same name.
- The task is to arrange each type of product in one row and list the Name and Color of each product.
- Solution: Use SPL XLL to group the data by Type and then by Name in each group. Concatenate the Name and Color of each group, using the conj function.
- Download esProc Desktop for Excel data processing and SPL programming.
Read Full Article
6 Likes
For uninterrupted reading, download the app