Excel VBA/Pivot: Table shows data to right of category not below

ouestque used Ask the Experts™
How do I convert the data below using a pivot table. If this can not be done with a pivot, then what is the fastest VBA code that can do the same thing.


     A          B
Tommy    98
Tommy    90
Tommy    22
Larry        12
Larry        99
Billy          52
Joe            34
Joe            55
Joe            67
Joe            96


Tommy   98   90   22
Larry       12   99
Billy         52
Joe           34   55   67   96
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
hi there, can you send your file plz
Hello plz try the attached.
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Hi there,

Please find attached, In VBA_Version Tab just click Expand Table button.

For Pivot Method you need to add helper column as you can check in Pivot_Version tab. Design Pivot without Grand Total, SubTotal and in Tabular Form.

Hope this is what you are looking for....
Hello Sir, i was about to put 3rd clum but i didnt bcoz he might need but i like that VB's Version perfect..

i have posted one question, is it possible if you can help me out in that plzzz



Thank you so much everyone for your feedback!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial