I have column A with case numbers and column B with names. It's basically listed row by row (Example A)and I want it to be listed like Example B with each name listed in columns and not rows.

I'm sure this is something simple, but nothing I've done so far is working and I'm hoping someone can help me with this.

thanks in advance