How to convert row as column header without duplication and update the values based on the field

[Palaniyappan (Palaniyappan P)]

Hi
Did these threads help us on this

How to transpose row to column in datatable?

Hi, I have an example datatable here. [190704%2015_03_16] I want to change row to column. It looks like here. [190704%2015_03_24] How can I do this?

Transpose row to column

Hello. I need a little help for traspose row items (with value > 0 or not null) form a data table into columns, and create excel file for each row. Here is my main excel file: [Main%20Tabel] I filter it for each row that “total_com” >“0” to get items ftom “00056”, “00057” etc and what i want is to create an excel file with two columns having the header A1: " COD" and B1: “CANT” and to get the values as in this pic: [Result%201] [Result%202] [Result%203] Each File must be saved as an exce…

Cheers @Abisha