MattG Posted August 1, 2013 Share Posted August 1, 2013 I am fully aware that this probably won't be possible before I ask, but I figure why not. I am curious if anyone has ever come up with a method for formatting summarized columns in a worksheet as a row, if that makes any sense. I have noticed on multiple occasions that this would be much cleaner for presentation purposes. I am adding two files with images as examples. In the one item I made a excel document where I attempt to illustrate what I mean, the other is an example where this would be cleaner in a current project. In a example I have a custom made truss piece record I apply to all my entertainment trussing pieces. When I draw up a job I can than pull out a report summarizing the pieces I would like. Great so far. Now I want to make a spreadsheet for the guys installing the show as to how many pieces of truss and what types make up a lighting position. Okay I can summarize by the position field I made in my record. All good, but now I have in some instances 4 rows or more of the items that make up this position. The first column in them all is the position. I would like to take that column and make it a row that would look like a divider of sorts between positions. This is I believe a product of the lighting guy in my that has been familiar with Lightwright. On the instrument schedule in light wright you can make data appear with a header that is summarized by position. It looks cleaner. I am attaching a image. I am fully aware this probably won't be able to be accomplished, but curious if anyone has any ideas on how to do this. Matt Quote Link to comment
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.