Single Column can have 2 different datatype

Hi All,

Appreciating your efforts in advance.

I have an excel table report in which actual data (for calculation start from row 4 )

as you can see 1st 3 rows are static and in the output file we want to show the sum of the value mentioned in the "Value" column.

we want the same format

I have tried separating these rows and apply union in the end but still, when I am exporting results in excel it is giving me the error of datatype.

Thanks,

Kuldeep

Workflow

Datasets

Developer

Custom Tools

Batch Macro

Accepted answers

Sorry, my bad please find the workflow attached.

You can write the second table to range A3:Z9999.

Workflow:

Output:

Hope this helps : )

can you plz share your updated workflow?