I have a database with the structure:
Region | OpenServicesID | DFC
K00001 | 1400 | 4
K00002 | 1300 | 3
K00001 | 1200 | 4
K00001 | 1100 | 4
K00002 | 1000 | 4
I have to present the data table in the following format:
Region | OpenServicesID | DFC | OpenServicesID | DFC | OpenServicesID|DFC
K00001 | 1400 | 4 | 1200 | 4 | 1100 | 4
K00002 | 1300 | 3 | 1000 | 4 | Null |Null