A. 1) I can do it in another sheet, say Sheet2
2) if column1 row1 of data is blank (or inconsequential)
3) if there is a blank column available to the left of where data would be posted in Sheet2
B. It can be done using the QUERY function, as shown in Sheet3
so here we go ...