Hi,
I have the following data being returned in my query.
ExternalReference NominalAccountRef NominalCostCentre AccountName
277828 4001 21 Sales - Pumps - C&U
277828 4010 21 Sales - Packaged Systems - C&U
277828 4012 21 Sales - Accessories EPC - C&U
277828 4080 21 Carriage - EPC - C&U
277828 4512 21 Accessories - C&U
I would like it to be displayed as follows:
ExternalReference NominalAccountRef NominalCostCentre AccountName NominalAccountRef NominalCostCentre AccountName NominalAccountRef NominalCostCentre AccountName NominalAccountRef NominalCostCentre AccountName NominalAccountRef NominalCostCentre AccountName277828 4001 21 Sales - Pumps - C&U 4010 21 Sales - Packaged Systems - C&U 4012 21 Sales - Accessories EPC - C&U 4080 21 Carriage - EPC - C&U 4512 21 Accessories - C&U
Can this be done ?