How to remove some duplicate info

[Meerza]

Hello.

I'm New in QS. Currently I have sample table below:

Due to cells A3,C3,A4 and C4 is repetitive, i would like to eliminate the data and still remain the name on column B

[Mark_Little]

Can you expand?

Do you mean you what to remove the Data on load i.e. don't load row 3 or is this just a want to show the table different in a visual?

[Meerza]

Actually, all three names belong to single account number. That's  why i want to remove the repetitive info but not the name.

[rwunderlich · Accepted solution]

You can retain just the first name for each Number/Acc combination with 

LOAD
  FirstValue(CustomerName_UMA3_Final),
  etc...
From ...
Group By Number_List_UMA3, Acc_No_UMA3_Final;

Or concatenate all three names together in a single row with:

LOAD
  Concat(CustomerName_UMA3_Final, ', '),
  etc...
From ...
Group By Number_List_UMA3, Acc_No_UMA3_Final;

-Rob

[Meerza]

Thank you very much for the solution. 🙂