Reports - Raw Data | Community
Skip to main content
Newcomer
August 13, 2024
Question

Reports - Raw Data

  • August 13, 2024
  • 2 replies
  • 1 view

I would like to know if it is possible to get raw data more comprehensive and easy to present. What I mean with this is that instead of putting for example the sign-in-out per people in rows, could that be on columns, so it could be easy to manage in Excel? The same thing applies to the people assigned to a queue, where they change to multiple auxiliaries, (bath, meal, downtime Manager Approved, etc.) starting time can be in one column, and the end time in another column, just instead of everything in rows,

Thank you in advance for your assistance.

    2 replies

    Newcomer
    June 17, 2025

    Hi user, did you get a response on this question. All my data is in one row, can it be distributed in different columns? To be easily filtered? 

    gersonc96Author
    Newcomer
    June 17, 2025

    Hi, no I did not receive any answer from Zoom. They suggested to submit a feature change, but it has not changed anything. What we did with the team is to paste the raw data in the Column A, and in Colum B we use this formula for Sign In. =INDEX($A$1:A100, (ROW(B1)-1)*2 + COLUMN(B1)-1), and for Sign Out. =INDEX($A$1:A100, (ROW(C1)-1)*2 + COLUMN(C1)-1), I hope this help you

    gersonc96Author
    Newcomer
    June 17, 2025

    Hi, no I did not receive any answer from Zoom. They suggested to submit a feature change, but it has not changed anything. What we did with the team is to paste the raw data in the Column A, and in Colum B we use this formula for Sign In. =INDEX($A$1:A100, (ROW(B1)-1)*2 + COLUMN(B1)-1), and for Sign Out. =INDEX($A$1:A100, (ROW(C1)-1)*2 + COLUMN(C1)-1), I hope this help you