Thread: Sorting

Hello to the community. This is my first post and am looking forwrd to browsing your forums to see what solutions have been found.

I have a spreadsheet that lists name "first last" in column A and the header is number by columum 1 - 40 sequentially. The data has a consistent format but can contain any cariation of 200 different entries. While this can be sorted sequentially from right to left, I am looking to align each cell into a column with like values. Current view is attached.

Prefer final state to appear something like:

1 2 3 4 5 6 7 8
Jon Smith 085, example 086, example 087 example 088, example 089, Example 090, Example NA# NA#
Suzy Lee 085, example 086, example 087 example na NA# 090, Example NA# 091, Example
Brandon Brown 085, Example 086, example 087 example 088, example NA# 090, Example NA# NA#

Appreciate any help.

Thanks