How to create Pivoted Table in Sharepoint List

Hello everyone is there anyway we can create a new list as pivoted table from another list. same as in access database or sql server admin? thank you.