can you turn a 1998 grand am se v6 auto into a standard trans ad what trans fits?

i have aa 1998 grand am se with the 3.1 i want to make it standard can i do it and if so witch trans would fit behind the motor and what do i need to do the switch