8 Replies Latest reply: Oct 11, 2017 6:58 PM by Lech Miszkiewicz RSS

    how to create excel report with 3 columns/tables

    David Atkins

      I need to produce a report that has 3 columns listing items that have been bucketed into those columns. The data is a list of items that can be grouped into a status of red/yellow/green and the goal is to have those be 3 separate lists across the page:

       

      Red     Yellow     Green

      1.         1.               1.

      2.          2.               2.

                     3.               3.

                     4.

       

      now the data would naturally sort as

      red

      red

      yellow

      yellow

      yellow

      yellow

      green

      green

      green

       

      but that is not the desired format

       

      and this data is grouped so it all wrapped in pages and sections