=query(,'Select * where Col1 is not null') The above formula combines and pulls data vertically and in the same way, the below formula combines the data horizontally (number of rows must be equal). First is Google Sheets, where you will be building your actual bracket. How to add brackets in google sheets to make the brackets permanent in your original cells.
