Right now a typical pivot table looks like this: enter image description here

This takes up too much room horizontally. I want to format it so that it is narrower and taller, by moving nested blocks down and left.

How can I format it so it looks like this:

    Cedar, E. Wht. -- Skybound
      #10 Growbag (42 qt)
        12-24 in.           1    %120
        2-3 ft             17    $120

The pivot table in Google Sheets is almost impossible to format, it drives me nuts! Often I use Query instead. I'm not sure if that will work for you your example, but take a look here on the example sheet here: https://productforums.google.com/forum/#!topic/docs/zLQMJAtsNLo;context-place=forum/docs

  • The downside of using a query is that queries are almost a 'write only' language with their escaped multiple systems syntax, AND they aren't gracious about changes in the source table. I have a pivot table that is 6 layers deep (hence the original request). I am not looking forward with joy and bliss creating a querry to do this. – Sherwood Botsford Jan 25 '18 at 15:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.