HI All,

May i know any formula i can apply for following beside CONCATENATE & macro?

Untitled.jpg

Result to appear as --> 2 ANDY, 5 SARA, 1 KIKI, 1 LALA
In some cases, row 1 might be blank. So if Row 1 are blank. The result will be 5 SARA, 1 KIKI, 1 LALA

Really hope to get help on this.
TIA