SQL output display

Morning all, I'm trying to change the design of the output of my results For example Select a, b From table1 Where a like '500%' Output will result A b 500 user1 500 user 2 2500 userx 2500 usery I want to display it as A b 500 user1, user2 2500 users, usery Apologies if this is confusing, using my phone to type this. Thanks in advance.