Hi Kdoyle5,


Check the checkbox against "Classic pivot table layout.. " under Display tab of Pivot Table options and then you can easily drag the account number to column B, see attached:-


05302012 My Memec Backlog.xlsx
Regards,
DILIPandey

<click on below 'star' if this helps>