Suppose both Sheet1 and Sheet2 contain 10 rows of data, open Append Worksheet dialog, choose Append by Row, check the Append to End of Each Column checkbox, click OK.
Change parameters to open dialog, click OK directly.
==> Result output to rows after 20th, leaves the first 20 rows empty.

Similar issue exists with the Transpose tool.

Fixed in Origin 2026 SR1