SarahDetroja
New Member
- Joined
- May 13, 2020
- Messages
- 18
- Office Version
- 2013
- Platform
- Windows
INPUT
Please see the sample file.
There would be hundreds of records like these. Please note columns can be reshuffle if it helps.
OUTPUT
We want a report. Obviously, the report should be based on a unique email....
peter@google.com
mary@google.com
david@google.com
jane@google.com
PS: I have tried Pivot table but not getting perfect output.
Please see the sample file.
There would be hundreds of records like these. Please note columns can be reshuffle if it helps.
OUTPUT
We want a report. Obviously, the report should be based on a unique email....
peter@google.com
mary@google.com
david@google.com
jane@google.com
PS: I have tried Pivot table but not getting perfect output.