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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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