Empty fields in a report - how to hide???

Empty fields in a report - how to hide???

Hi - I'm finding it really hard to believe there isn't a simple solution to this, so perhaps someone on here can help.  It would be greatly appreciated.

I have a large form with many optional fields.  Some of these optional fields are single line, others are image fields, whilst others are drop-downs.

As they are optional, most of these fields will be left empty; others will have a 'none' value, which for my purposes amounts to the same as an empty field. 

How can I prevent my report being littered with unecessary empty and 'none' fields?  Given that hiding empty fields is so easy on a form using simple script, surely there must be an easy way to create a report that hides fields based on a specific value or on a 'null' entry?

Image attached to illustrate issue.


 
    Zoho Marketing Automation

          Zoho Pagesense Resources

            Zoho SalesIQ Resources



                  Zoho TeamInbox Resources

                    Zoho DataPrep Resources



                      Zoho CRM Plus Resources

                        Zoho Books Resources


                          Zoho Subscriptions Resources

                            Zoho Desk Resources

                              Zoho Projects Resources


                                Zoho Sprints Resources


                                  Qntrl Resources


                                    Zoho Creator Resources


                                      Zoho WorkDrive Resources




                                          Zoho Campaigns Resources

                                            Zoho CRM Resources

                                                    Design. Discuss. Deliver.

                                                    Create visually engaging stories with Zoho Show.

                                                    Get Started Now