Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated Field in Pivot Table Based on Two Counted Fields | Excel Discussion (Misc queries) | |||
Pivot table # of fields | Excel Discussion (Misc queries) | |||
Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) |