people assigned to a project - how to know who to go to for each?

djveed

New Member
Joined
Nov 18, 2014
Messages
14
Hi everyone! I have a list of programs and for each of them, a list of names that worked on the program, anywhere between one and four people. If I want to synthesize this data and know, for example, what programs should i ask "Geoff" about, how do I do this in Excel?


ProgramPerson APerson BPerson CPerson D
Program CNBCAngela Geoff
Program CNNAshley Shelby Geoff
Program ZTVAshley Shelby Angela Chris
Program ESPNGeoff James
Program FoxAshley Shelby Chris

<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
6,800
something ike this?

ValueProgram
AngelaProgram CNBC, Program ZTV
GeoffProgram CNBC, Program CNN, Program ESPN
AshleyProgram CNN, Program ZTV, Program Fox
ShelbyProgram CNN, Program ZTV, Program Fox
ChrisProgram ZTV, Program Fox
JamesProgram ESPN
 

djveed

New Member
Joined
Nov 18, 2014
Messages
14
Yes! Something like that. How do I do that in Excel? Obviously I have far more than the six names listed in my data file.
 

djveed

New Member
Joined
Nov 18, 2014
Messages
14

ADVERTISEMENT

are you able to use PowerQuery (Get&Transform) ?
Actually I'm not totally sure. I'm pretty sure I have access to that but I've never used it.
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
6,800
Excel 2010/2013 - PowerQuery add-in
Excel 2016 and higher - built-in aka Get&Transform
 

djveed

New Member
Joined
Nov 18, 2014
Messages
14

ADVERTISEMENT

Okay. I may not actually have access to that add-in. Can you help me with this? My data file is only 20 Projects long.
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
6,800
you can download PowerQuery add-in from MS site, it's free
if not - I can't help

if you want use PQ you must have this add-in, if not you must wait for someone else with another solution
 
Last edited:

djveed

New Member
Joined
Nov 18, 2014
Messages
14
Thank you! Let me try this. If this doesn't work - is there any way to do this without the add-in? Anyone know?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,462
Messages
5,528,950
Members
409,848
Latest member
Blomsten
Top