Single Column can have 2 different datatype

[Kuldeepmathur]

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

[atcodedog05]

Hi @Kuldeepmathur 

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

Workflow:

Output:

Hope this helps : )

[Kuldeepmathur]

can you plz share your updated workflow?

[atcodedog05 · Accepted solution]

Hi @Kuldeepmathur 

Sorry, my bad please find the workflow attached.