Combine multiple fields with query and consolidate?

Jwise

Hi!

Is it possible to have multiple fields combine? I see the filter by query and consolidate functions, but need the ability to combine columns automatically

Support from Sheetgo

Jwise certainly possible!

Add multiple sources to enable the consolidate and then add a query block in between source and destination. To select specific columns, use a query such as this one: SELECT B,E,F

This gets you columns B, E and F from those multiple sources.