Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am working with a straight table. I would like my field names to go from top to bottom in the first column with the value to the right of the field name. By default, the field names are on top and the value from the table are below the field names. I figured out how to get what I want using a pivot table, but there is a lot of dragging, dropping and rearranging and being that I have 18 tables to build this method would be very time consuming.
My straight table looks like this right now.
Name | Date | Address | Phone |
John Doe | 01/01/01 | 555 Some St. | (555)555-5555 |
Jane Smith | 01/02/02 | 555 Another St. | (111)111-1111 |
Jerry Curl | 01/03/03 | 555 Main St. | (222)222-2222 |
I'd like it to look like this.
Name | John Doe | Jane Smith | Jerry Curl |
Date | 01/01/01 | 01/02/02 | 01/03/03 |
Address | 555 Some St. | 555 Another St. | 555 Main St. |
Phone | (555)555-555 | (111)111-1111 | (222)222-2222 |
Is there a setting to change this or how can I accomplish this?
Thanks for the help guys!
Jason
Hi!
If you use a chart 'Single Table', under "Presentation" is the option 'Horizontal'.
In the table there is no such option.
Rebeca
Hi!
If you use a chart 'Single Table', under "Presentation" is the option 'Horizontal'.
In the table there is no such option.
Rebeca
Go to presentation tab and choose horizontal tick box
Thanks!! I found it and it works great. I'm a rookie!