Jump to content
Sign in to follow this  
Jarvis

Transposing Table View

Recommended Posts

In MS Excel there is a simple command to transpose data.

To do this you copy a row of values then perform a process called "paste special > transpose". Anything that was a row becomes a column and anything that was a column becomes a row.

Is there a way to do something like this in table view?

What I would like to have is my fields arrayed in column format

with all the record values distributed horizontally across the page like a spreadsheet.

In this example the text "CUT DOORS" etc would be a field name

and the text A:B:C would be values for each record.

This would give me a graphical spreadsheet to monitor production status.

Any ideas how to do this?

Thanks,

Jarvis

checklist.JPG

Share this post


Link to post
Share on other sites

I know what you mean. I have long wished for the ability to create "horizontal" portals for the same reason. It would be nice to be able to display records horizontally rather than vertically in the table or list views was well.

If your business plan doesn't change much you can display the data horizontally by creating a relationship for each "column" of data and displaying it as a portal. I've even resorted displaying a 10x10 grid by defining a relationship for each square in the grid... it does not make a pretty relationship graph.

Share this post


Link to post
Share on other sites

Perhaps you could make use of this method.

Crosstab reports

Share this post


Link to post
Share on other sites

Thank you John.

This may indeed be what I am looking for.

I will need to stare at it a bit longer to be sure.

Jarvis

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.