I am trying to output some data in a specific format and I am not sure if it is possible.
Please could someone point me in the right direction?
(sorry if I posted this in the wrong section or if it has been covered before)
the data needs to look something like this and comes from a single query
Record 1
Field1 from rec1 Field2 from rec1 Field3 from rec1
Field4 from rec1 Field5 from rec1 Field6 from rec1
Some non dynamic data
Record2
Field1 from rec2 Field2 from rec2 Field3 from rec2
Field4 from rec2 Field5 from rec2 Field6 from rec2
same non dynamic data
Record3
Field1 from rec3 Field2 from rec3 Field3 from rec3
Field4 from rec3 Field5 from rec3 Field6 from rec3
same non dynamic data
etc