3 ms·

I once needed to pivot a table. Tried it with excel, spent an hour googling, couldn't get it to work. Then exported it into SQL server, googled how to do it in

I once needed to pivot a table. Tried it with excel, spent an hour googling, couldn't get it to work. Then exported it into SQL server, googled how to do it in T-sql, and was done shortly after. Respect for people who work with excel, but it's not for me.

moron123 5y ago
Roughly, Step 1: Insert pivot table Step 2: Set data source Step 3: set row (pivots) Step 4: set value (summary)