Forum Discussion

Del's avatar
Qrew Cadet
5 years ago

Flip Report, Transpose

Trying to flip or transpose a table report. I have a simple one to many relationship and a simple table report but grouped by a date field - 'week'.

I want to create a table report but one that is flipped horizontally with the child records appearing as rows instead of columns.


10 Replies

  • well, you could copy to Excel and then edit paste (all)
    then edit paste special transpose into a new sheet

    But other than that, wow, that is a hard one.

    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    • Del's avatar
      Qrew Cadet
      Tried to find how to do this everywhere but failing miserably. Hope this can be a native feature soon

      • DonLarson's avatar
        Qrew Commander

        It sounds easy but is actually a completely different report.   Excel makes it looks simple but the spreadsheet is not really a reporting system, we just make the cells line up to be pleasant on the eye.

        Do you have any BI/BA tools like Tableau or Power BI?  We can get the data out of QB and then put an embedded report from one of those into Quick Base.

        Don Larson
        Westlake OH