LISTING

[upaliwije]

Hi Friends

In my QV Document I have following table

I want to rearrange this table to look like below. Pls advise  how to do it

[sunny_talwar · Accepted solution]

May be like this

Table:

LOAD ACCOUNTANT,

     BRANCH

FROM ....

Concatenate (Table)

LOAD ACCOUNTANT,

     COS_CENTRE as BRANCH

FROM ....

Where Len(Trim(COS_CENTRE)) > 0;