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:
Is that possible?
Please Login or Register to view this content.
Thanks for your help!
Craig
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
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
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
Last edited by JBeaucaire; 07-15-2016 at 10:12 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
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
Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.
This worked.
Originally Posted by Special-K
Last edited by JBeaucaire; 07-15-2016 at 10:14 AM.
and this worked
Last edited by JBeaucaire; 07-15-2016 at 10:13 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks