Adding two rows to an output file above the headers

Question

Hello,

I produced a file with headers and values. I want to insert two rows above the headers with a different set of headers and values. How would I do that?

I tried to create a Text to Value input and then UNION with the output file but it just added to the headers on the right, not above.

See expected file attached as well as the actual file

Expected Results.xlsx

Actual Results.xlsx

atcodedog05 · Accepted Answer

Hi @theamandagail

Configure it to write to a range like below.

You can set the range in this window

This way both tables are written into separate ranges one above the other.

Hope this helps : )

binu_acs · Accepted Answer

@theamandagail the union tool also should work