Pivot Table - multiple rows to columns

tholder

New Member
Joined
Feb 16, 2011
Messages
11
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!
 
Forgot to mention the code is written for older Excel version, thus the Range "A65536". Since you're using Excel 2010, if you have more than that number of rows you can edit code.

Also, my fault for not reading your initial post correctly . . . you DID say all on one row, I just didn't read it that way. When I said I've read articles that say Excel 2010 can do it - I meant Excel 2010 can automatically fill down the Company Name for you without having to go thru the gyrations I described.
 
Upvote 0

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Work became insane today so I am going to try your code in the morning. Thanks for all your help; I'll let you know how it goes!
 
Upvote 0
I used your code this morning and it worked like a charm! Thank you for all your help; I really appreciate it.
 
Upvote 0

Forum statistics

Threads
1,223,909
Messages
6,175,312
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top