I was wondering if it would be possible to display the column level data as row level in Velixo. So its like the columns of a GI should be displayed as rows and the values of those next to it. I have shared a format of the same in the screen.
The =WRITEBACK*****() functions reference actuals cells in the spreadsheet, there's no problem having a writeback function reference column-level ranges vs. row-level ranges. If you face any issue feel free to post here!
Gabriel
0 Votes
H
Harshita Sethiaposted
about 17 hours ago
And in case if I am also looking to do a writeback for all those listed rows with a new data.
0 Votes
Gabriel Michaudposted
3 days ago
Admin
Dear Harshita,
The TRANSPOSE() function in Excel is what you're looking for! Just do =TRANSPOSE(GI(Connection...)) and it will do its magic.
0 Votes
Hello all,
I was wondering if it would be possible to display the column level data as row level in Velixo. So its like the columns of a GI should be displayed as rows and the values of those next to it. I have shared a format of the same in the screen.
Thanks in advance,
Attachments (2)
Screenshot 2....png
275 KB
Screenshot 2....png
376 KB
0 Votes
3 Comments
Gabriel Michaud posted about 3 hours ago Admin
Harshita,
The =WRITEBACK*****() functions reference actuals cells in the spreadsheet, there's no problem having a writeback function reference column-level ranges vs. row-level ranges. If you face any issue feel free to post here!
Gabriel
0 Votes
Harshita Sethia posted about 17 hours ago
And in case if I am also looking to do a writeback for all those listed rows with a new data.
0 Votes
Gabriel Michaud posted 3 days ago Admin
Dear Harshita,
The TRANSPOSE() function in Excel is what you're looking for! Just do =TRANSPOSE(GI(Connection...)) and it will do its magic.
Happy reporting,
Gabriel
0 Votes
Login or Sign up to post a comment