| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup to transform columns to rows
Hi,
I have data, for example: Empl No. Emp First Emp Last Dependents Dep1 Dep2 Dep3 98789991 John Doe Mary Mary Jim Suzie 98789992 John Doe Jim 98789993 John Doe Suzie 87656781 Marie Smith James James 89986661 Mark White Janet Janet Al 89986662 Mark White Al after which I can delete the no longer necessary rows. Any help would be greatly appreciated! I have added the 1, 2, 3, etc. to the end of the Empl Number to denote numbers of dependents through a formula. I would like to transform the Dependent column to Dependent1, Dependent2, Dependent3, etc. through a formula that looks up the Empl No and, based on the number at the end of it, puts the correct dependent name in those columns, as: Empl No. Emp First Emp Last Dependents Relationship 98789991 John Doe Mary Wife 98789992 John Doe Jim Son 98789993 John Doe Suzie Daughter 87656781 Marie Smith James Husband 89986661 Mark White Janet Wife 89986662 Mark White Al Son -- Thanks! Dee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Vlookup by rows and columns | Excel Worksheet Functions | |||
| how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) | |||
| How can I transform several rows into 1 column in excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
