The attached document is a time-sheet document. There are 2 tabs,
I want to pull through data from
TimesheetData tab to the
InvoiceData tab using a query.
The query I have set up in the InvoiceData tab is:
=QUERY(TimsheetData!A:BD, "SELECT* WHERE A = 'Yes' and B is Null ORDER BY F DESC")
However, I do not want to pull through all of the columns and column headers, I only want to pull through the columns and column headers that have data.
In my QUERY results in
InvoiceData tab, I want to remove the columns and column headers that have no data and be left with columns and headers that have data.
In the link attached, in the
InvoiceData tab, I have highlighted in red the columns and headers that need to be deleted.