| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicate rows Elimination- change rows accordingly
I have a Excel sheet with names in Col A, hours in B and Amount in C.
My problem is names have duplicate rows. I want to make it unique and accordingly the B and C should be added to the unique name row. Thanks in Advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Duplicate rows Elimination- change rows accordingly
create a pivot table from your data.
Data=Pivot Table . . . make A and B the row fields and C the Data field. -- Regards, Tom Ogilvy "meendar" wrote: I have a Excel sheet with names in Col A, hours in B and Amount in C. My problem is names have duplicate rows. I want to make it unique and accordingly the B and C should be added to the unique name row. Thanks in Advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Duplicate rows Elimination- change rows accordingly
Sorry, misread the layout. make A the row field and B and C the data fields.
-- Regards, Tom Ogilvy "meendar" wrote: I have a Excel sheet with names in Col A, hours in B and Amount in C. My problem is names have duplicate rows. I want to make it unique and accordingly the B and C should be added to the unique name row. Thanks in Advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert rows in a worksheet that do not change adjoining rows | Excel Discussion (Misc queries) | |||
| Duplicate rows into new rows based on row value | Excel Worksheet Functions | |||
| process of elimination of duplicate information | Excel Discussion (Misc queries) | |||
| How do change rows to colums AND columns to rows | Excel Discussion (Misc queries) | |||
| Cell content elimination; duplicate | Excel Worksheet Functions | |||
Hybrid Mode
