I have over 15,000 rows in a database that I am working on, one column in the
database contains numbers. Some of the numbers are listed more than once so
they occupy multiple rows in the column. One word is also associated with
the number in a separate column. The same and different words can be found
within the rows of the same number and also between the different numbers.

What I am trying to do is consolidate the rows with the same number, and the
words associated with that number, into one row (so that each number is only
shown once (in its own row), and only one representative word, of those
mentioned for that number, remains, and those are all listed together in that
row).

*Many other columns of data are also associated with each number, although
the information varies between differing numbers it is the same for the same
number which is listed in multiple rows.