Col 1 = Job numbers Col 2 = Task numbers Col 3 = Date
I would like to have:
Col 1 = Job numbers All other Col = Dates with Col 2 as headers transposed
So something like:
query(DATA,"select * offset Col 2") or transpose somehow?
Problem is that offset in query offsets rows not columns as far as I can see in online forums etc.