Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose certain data
Hi eeryone-
I have excel data where is lists a person on a new row for each project they work on. Fro example: ID Name Project Name 101 Person 1 Project 1 101 Person 1 Project 2 101 Person 1 Project 3 102 Person 2 Project 1 102 Person 2 Project 3 I need to figure out a way to get the data to look like this: 101 Person 1 project 1 project 2 project 3 102 Person 2 project 1 project 3 ect... Each person has their own unique ID number. Please help. thank you very much! -Brian |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose certain data
Let's say your header from A1 to C1
A2:A6 = ID B2:B6 = Name C2:C6 = Project Name and you want to look for... 101 in E2 102 in E3 In F2 =VLOOKUP(E2,$A$2:$B$6,2,0) In G2 =IF(ISERR(SMALL(IF($A$2:$A$6=$E2,ROW(INDIRECT("1:" &ROWS($C$2:$C$6)))),COLUMNS($A:A))),"",INDEX($C$2: $C$6,SMALL(IF($A$2:$A$6=$E2,ROW(INDIRECT("1:"&ROWS ($C$2:$C$6)))),COLUMNS($A:A)))) Formula in G2 is an array formula you have to commit ctrlshiftenter (not just enter) copy as far as suite your need "BCLivell" wrote: Hi eeryone- I have excel data where is lists a person on a new row for each project they work on. Fro example: ID Name Project Name 101 Person 1 Project 1 101 Person 1 Project 2 101 Person 1 Project 3 102 Person 2 Project 1 102 Person 2 Project 3 I need to figure out a way to get the data to look like this: 101 Person 1 project 1 project 2 project 3 102 Person 2 project 1 project 3 ect... Each person has their own unique ID number. Please help. thank you very much! -Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inconsistent Sorting | Excel Discussion (Misc queries) | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Hi all i need some help on excel transpose | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
How do I repeatedly transpose blocks of data? | Excel Discussion (Misc queries) |