Hello,
I've applied a Pivot from my raw data
Column A, B, and C has all the same data (see attachment)
But for a single Company, I have 4 different e-mail ID's (see column D in attached)
I want all the 4 E-mail ID's in each different cells (see below)
A B C D E F G
ABC CORPORATION 121234345 North East Side [email protected] [email protected] [email protected] [email protected]
Bookmarks