Merge multiple rows containing different values into one row

0 votes

1 answer

3548 views

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

Asked by Prateek (9 rep)

Aug 10, 2020, 12:26 PM
Last activity: Apr 21, 2025, 11:08 PM

Merge multiple rows containing different values into one row

Related Questions