Insert multiple rows from a query

[Barrier]

Is it possible to insert the results of a lookup in multiple rows/columns?

For example, a LOOKUP yields: 1, “a”, 42

I would like to insert that data in three consecutive rows or colums.