I am a complete newbie to Alteryx so any help will be much appreciated.
I want to find out which patients were seen by Dr A as a 1st physician and as 2nd physician.  
Dr A is the value that I want to search for in column 2 and column 3 but for each patient. Dr A will not be repeated for a patient so Jacob can only have 1 Dr A and Dr A will either be in column 1 or column 2 for a given patient.
| Patient Name | Physician 1 | Physician 2 | 
| Jacob | Dr A | Dr X | 
| Jacob | Dr B | Dr Z | 
| Jacob | Dr C | Dr P | 
| Mike | Dr X | Dr A | 
| Mike | Dr Y | Dr B | 
| Mike | Dr Z | Dr P | 
| David | Dr A | Dr W | 
| David | Dr Z | Dr X | 
 
					
				
				
			
		
