answersLogoWhite

0


Best Answer

Put the data into Excel if it is not already in it. Then select the table and do a copy. Go to a blank area of the worksheet. Right click to open the shortcut menu and then choose Paste Special and then Transpose. You table will be transposed in the new location.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the best method to use to transpose a table which is laid out horizontally into one laid out vertically?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How does atomic radius increase or decrease horizontally or vertically across the periodic table?

Increases vertically as you add new shells, decreases horizontally because you have more protons in the nucleus


What is the trend for atomic radius horizontally and vertically on the periodic table?

Horizontally: decreasing from left to right.Vertically: increasing from top to bottom.


What is the best method to use to transpose a table which is laid out horizontally into one laid out vertically on excel 2007?

There is a TRANSPOSE function, if you want to retain both tables and have the first one update the second one when changes are made. There is also a Transpose option if you do a Copy and then use Paste Special. It will not maintain a link between the two, so is better to use if you only want one version and have it laid out in the other format than you started with. You cannot use it with Cut, just Copy, so normally you would make the copy and then delete the first one, and possibly then move the second one.


How many vertical rows are on the periodic table?

There are NO vertical ROWS, because rows run horizontally, and COLUMNS run vertically. There are 18 vertical columns in the periodic table.


What is each horizontal row of the periodic table called?

vertically they're called groups and horizontally periods


What is a periodic row?

On the Periodic Table of elements, elements that align horizontally are said to be in the same row, and objects that align vertically are said to be in the same group.


What is group 17 period 5 on the periodic table?

Iodine. (Always remember, groups go horizontally, periods go vertically) -Ali, Muhammad.


Which way are periods on a periodic table?

Periods are horizontal.Groups are vertical.Just think group = up and downperiod= right and left


How are groups on a periodic table numberd?

From right to left (1- 18) on the periodic table. Instead of up and down (1-7) periods go vertically. (rows) groups go horizontally. (columns)


How does the atomic radius increase or decrease horizontally on the periodic table?

Atomic radius decreases horizontally in periodic table. This is due to increase in nuclear charge.


Where are periods located on the periodic table?

Periods are placed horizontally in the periodic table of Mendeleev.


Going vertically across the periodic table is?

good ??????????????????????????????????????????????