Sheets Exercises
Start free Sheets lesson

Members lesson 23

Rows and columns

Turn grouped sales into a cross-tab with row and column fields.

What you will practice

  • Add a field to pivot columns
  • Build a row-and-column cross-tab
  • Turn a cross-tab around
The first 15 lessons are free.
Join the members waitlistBack to all lessons
Lesson preview

Channel sales

Starting table
ABCD
1RegionChannelQuarterAmount
2EastDirectQ1840
3WestPartnerQ1720
4NorthOnlineQ1610
5EastPartnerQ2960
6WestOnlineQ2780
7NorthDirectQ2690
8EastOnlineQ31,030