Consolidating Fields
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. |
All times are GMT +1. The time now is 04:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com