| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it just me or is this tricky?
hey, i have a list of id numbers of students with phone numbers and types of number like this below - the problem is that each student has a different amount of numbers and different types of number ID TEL Num Type of Number g2045012 01755465464 PR1 g2045012 02114574684 BU1 g2045012 35346347373 MU1 g2045012 52141513613 PR2 h42376347 35236276247 MU1 h42376347 23624724727 PR1 h42376347 12362762462 BU1 adgh12322 15595683464 PR1 adgh12322 32473573478 MU1 i am tryin to change the layout so that it will be one line per id number with all the numbers on 1 row with an individual column for each different type of number(like below) can anyone help at all please!!!! ID PR1 BU1 MU1 PR2 g2045012 01755465464 02114574684 35346347373 52141513613 h42376347 23624724727 12362762462 35236276247 adgh12322 15595683464 12362762462 32473573478 -- philawde ------------------------------------------------------------------------ philawde's Profile: http://www.excelforum.com/member.php...o&userid=29030 View this thread: http://www.excelforum.com/showthread...hreadid=487582 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tricky data entry question | Excel Discussion (Misc queries) | |||
| Tricky ComboBox / Filter query | Excel Discussion (Misc queries) | |||
| Tricky Question | Excel Worksheet Functions | |||
| tricky conditional formatting | Excel Worksheet Functions | |||
| Tricky formulas needed | Excel Worksheet Functions | |||
Threaded Mode
