How can you best describe pivoting and unpivoting? Select an answer: Pivoting turns distinct column values into rows, and unpivoting turns distinct rows into columns Pivoting turns duplicate column values into merged rows, and unpivoting splits distinct rows into duplicate columns Pivoting turns distinct row values into columns, and unpivoting turns distinct columns into rows. Pivoting turns duplicate row values into merged columns, and unpivoting splits distinct columns into duplicate rows