Is it possible to convert data in a queried data?

Question

QUERY(otherSheets!A:B, "SELECT A B")

By using this line, I can get a temporary table that has two columns, A and B. Is it possible to add another column C, to the table by functions without showing it in a sheet and then manually editing it?

Answer 1

It sounds like your intention is to manually add data side-by-side with formula results. This exposes you to the risk of rows getting misaligned.

You probably should insert the new column to the existing data table instead of adding it to formula results.

See this thorough treatment of the row misalignment issue.