Hey all,
I'm running Excel 2010 on Windows 7. I have a Pivot Table with multiple companies and for each company there is anywhere from 1-5 employees (including a phone, email) listed. I need each person under each company to be on the same row as the company, so I can do mail merging.
For example I have this:
Company Name Phone Email
--------------------------------------
Company1 Person1 Phone1 Email1
Person2 Phone2 Email2
Company2 Person3 Phone3 Email3
Person4 Phone4 Email4
And I need:
Company Name1 Phone1 Email1 Name2 Phone2 Email2
-------------------------------------------------------------------------
Company1 Person1 Phone1 Email1 Person2 Phone2 Email2
Company2 Person3 Phone3 Email3 Person4 Phone4 Email4
Thanks for your help!
I'm running Excel 2010 on Windows 7. I have a Pivot Table with multiple companies and for each company there is anywhere from 1-5 employees (including a phone, email) listed. I need each person under each company to be on the same row as the company, so I can do mail merging.
For example I have this:
Company Name Phone Email
--------------------------------------
Company1 Person1 Phone1 Email1
Person2 Phone2 Email2
Company2 Person3 Phone3 Email3
Person4 Phone4 Email4
And I need:
Company Name1 Phone1 Email1 Name2 Phone2 Email2
-------------------------------------------------------------------------
Company1 Person1 Phone1 Email1 Person2 Phone2 Email2
Company2 Person3 Phone3 Email3 Person4 Phone4 Email4
Thanks for your help!