Writing the data to the excel worksheet wiuth different structure

Help
1

Hello guys,

I have the data in the data table

image
image1104×395 24.8 KB
we can consider the first schema as the data in the data table.)worksheet"sheet1".
Now I would like to write this data to the excel sheet attached which has a complete different structure as shown(the second schema). The issue is that the schema in the excel sheet is completely different. Could anyone help me with this. i will share the excel sheet as wellDataExcel333.xlsx (507.3 KB)

2

image

Why don’t you simply design it in excel using cell references to the appropriate cells?

DataExcel333_ExcelRefs.xlsx (507.7 KB)