Collapse table and create new columns

[HansS]

Hi @pranabjha

Or you try this solution. Its uses a GroupLoop (not always handy when dealing with large data sets) but it works. collaps_table.knwf (53.7 KB)

gr. Hans