How to group 1 to many relationship

**csh8428** · 07-14-2016, 11:07 AM

I have a dataset with a one to many relationship. I was trying to figure out how to group/format so the "many" part is only show once. A pivot table looks horrible and is not usable.

For example:

DATASET:
Boss(A)         Employee(B)                 Boss' email(C)
Brad              Mike                      Brad@gmail.com
Brad              John                      Brad@gmail.com
Kim               Scott                      Kim@gmail.com
Kim               Tyler                      Kim@gmail.com

I want i to look like this:
Boss(A)         Employee(B)                  Boss' email(C)
Brad            Mike                      Brad@gmail.com
                John                      
Kim             Scott                      Kim@gmail.com
                Tyler

Is that possible?

Thanks for your help!

Craig

**Special-K** · 07-14-2016, 11:17 AM

Helper columns and hide the original boss and boss email columns?

in D2
IF(A2=A1,"",A2)

in E2
IF(C2=C1,"",C2)
and copy down

**csh8428** · 07-14-2016, 09:59 PM

This worked.

Originally Posted by Special-K

in D2
IF(A2=A1,"",A2)

in E2
IF(C2=C1,"",C2)
and copy down

**csh8428** · 07-14-2016, 10:01 PM

and this worked

Originally Posted by JBeaucaire

CF rule for A2:C1000
=A2=A1
Formatting: Font - White

**JBeaucaire** · 07-14-2016, 11:22 AM

I would leave my original table 1 as is, the data is good data.

Then use Conditional Formatting to suppress the display of additional instances of names in column A and emails in column C.

CF rule for A2:C1000
=A2=A1
Formatting: Font - White

**shirleyxls** · 07-14-2016, 11:26 AM

I know you said you didn't like the pivot table option, but I managed to use one with a tabular layout and removed totals to get pretty much the same result.

Just a thought if you wanted to see it as an alternative