Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a Column as Row headings.
I would like to copy a column list as row headings. I would prefer that a
formula be copied and modified to do that job so that when I change a value in the column of entries, the row heading is changed automatically. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a Column as Row headings.
Lets say the column heading are in cells C10 thru C20 (modify to meet your
requirements) In A1 thru K1 enter: =C10 =C11 =C12 =C13 =C14 =C15 =C16 =C17 =C18 =C19 =C20 -- Gary's Student gsnu200707 "John Gilmer" wrote: I would like to copy a column list as row headings. I would prefer that a formula be copied and modified to do that job so that when I change a value in the column of entries, the row heading is changed automatically. Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a Column as Row headings.
"Gary''s Student" wrote in message ... Lets say the column heading are in cells C10 thru C20 (modify to meet your requirements) In A1 thru K1 enter: =C10 =C11 =C12 =C13 =C14 =C15 =C16 =C17 =C18 =C19 =C20 -- Gary's Student gsnu200707 That's what I have been doing. I'm VERY lazy (and somewhat geek oriented) so I want the C3....C50 entries to be made automatically. Aside from saving work it will also reduce the chance of a data entry error. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a Column as Row headings.
I see your point. In A1 enter:
=INDIRECT("C" & COLUMN()+9) and copy across. This is only one formula rather than many. The +9 is a bit artificial and will need to be adjusted if the list does not start in C10 -- Gary's Student gsnu200707 "John Gilmer" wrote: "Gary''s Student" wrote in message ... Lets say the column heading are in cells C10 thru C20 (modify to meet your requirements) In A1 thru K1 enter: =C10 =C11 =C12 =C13 =C14 =C15 =C16 =C17 =C18 =C19 =C20 -- Gary's Student gsnu200707 That's what I have been doing. I'm VERY lazy (and somewhat geek oriented) so I want the C3....C50 entries to be made automatically. Aside from saving work it will also reduce the chance of a data entry error. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a Column as Row headings.
"Gary''s Student" wrote in message ... I see your point. In A1 enter: =INDIRECT("C" & COLUMN()+9) and copy across. This is only one formula rather than many. The +9 is a bit artificial and will need to be adjusted if the list does not start in C10 OK. That's a start. I may have some questions down the line. For example, were I to want to sort the rows via the "key" entry, that would automatically change the column heads. BUT the data corresponding to the cross points would no longer be in the right place. But I will look into that "some other time." Thanks, again. -- Gary's Student gsnu200707 "John Gilmer" wrote: "Gary''s Student" wrote in message ... Lets say the column heading are in cells C10 thru C20 (modify to meet your requirements) In A1 thru K1 enter: =C10 =C11 =C12 =C13 =C14 =C15 =C16 =C17 =C18 =C19 =C20 -- Gary's Student gsnu200707 That's what I have been doing. I'm VERY lazy (and somewhat geek oriented) so I want the C3....C50 entries to be made automatically. Aside from saving work it will also reduce the chance of a data entry error. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a Column as Row headings.
You may want to look at the =transpose() function.
If your headers are in A1:A10 (10 cells) then select B1:K1 (10 cells, too) Type this formula: =transpose(a1:A10) but hit ctrl-shift-enter instead of just enter to fill that horizontal range. John Gilmer wrote: I would like to copy a column list as row headings. I would prefer that a formula be copied and modified to do that job so that when I change a value in the column of entries, the row heading is changed automatically. Thanks in advance. -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a Column as Row headings.
You've got a response to your other similar looking post in .newusers
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a Column as Row headings.
"Dave Peterson" wrote in message ... You may want to look at the =transpose() function. OK. I will check it out. Clearly I am creating a square matrix and matrix operators might be useful. Thanks again If your headers are in A1:A10 (10 cells) then select B1:K1 (10 cells, too) Type this formula: =transpose(a1:A10) but hit ctrl-shift-enter instead of just enter to fill that horizontal range. John Gilmer wrote: I would like to copy a column list as row headings. I would prefer that a formula be copied and modified to do that job so that when I change a value in the column of entries, the row heading is changed automatically. Thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I take information in 1 column to make column headings? | Excel Discussion (Misc queries) | |||
How do I create column headings in Excel in the A, B, C etc column | Excel Discussion (Misc queries) | |||
Copy Column headings to Rows | New Users to Excel | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
copy excel worksheet into msword with row, column headings and gr. | Excel Discussion (Misc queries) |