Hi, I have a strange requirement. I have attached images below for a better visual. I have a data which looks like below image and I need this to transform it to [image] This format. [image] I tried to use Extract column header, Cross join with ABC. But, I some how can’t relate to the logic of getting the number based on two reference. Appreciate you help and time. Thanks.

Hi @Braveen See this wf: customized_table_format.knwf (24.4 KB) . It uses a Unpivoting node inside a Group Loop. [image] gr. Hans

Customized table format

mlauber71 January 21, 2021, 2:45pm 5

@Braveen I have this collection about Loops and similar items

For loops you might want to take a look at these links:

2 Likes