How to pull multiple column data from another sheet

I am using the JOIN(COLLECT()) formula to pull data from another sheet. The issue is I can only pull from one column at a time. Is it possible to pull data from several columns using the JOIN(COLLECT()) referencing data from another sheet?

This is the current formula that I am using:

=JOIN(COLLECT({Roles/Access Range 6}, {Roles/Access Range 3}, [Department Cost Center]@row, {Roles/Access Range 1}, Position@row), ",")

I was wondering if the range "{Role/Access Range 6}" can be multiple columns.

Best Answer