Hi,
I am working with a very large file with Sub Account Names and their corresponding IDs. The IDs sit above the Sub Account name in the same column in the pivot table. I need to get them to be side by side (Column A = Sub Account names, Column B = IDs) without the IDs being converted into a value as that changes the ID number.
Attached is a small example file for the pivot table. Any and all help is greatly appreciated
Bookmarks