Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose problem
I have a spreadsheet with names in column A and dates along row 4. I now
realise that the maximum number of names I will have will be 100 to 150 but over say 10 years there will be 2500 t0 3000 dates. Therefore I need to transpose the data. My problem is that the list of names refers to a master sheet with names and addresses, set out conventionally. The list of names is sorted alphabetically and changes with additions and deletions. Is there a quick way to arrange that cell C4 on the current worksheet = A3 on the master sheet then D4 = A4, E4 = A5, F4 = A6 etc. without having to insert each value one at a time Barry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose problem
In C4 enter Code: -------------------- =indirect("mastersheet!a"&column()) -------------------- and drag to the right -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=47395 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose problem
Hi,
You can use =OFFSET(Sheet2!$A$2,COLUMN(A1),0) or =INDEX(Sheet2!$A$3:$A$19,COLUMN(A1)) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Barry Lennox" wrote in message ... I have a spreadsheet with names in column A and dates along row 4. I now realise that the maximum number of names I will have will be 100 to 150 but over say 10 years there will be 2500 t0 3000 dates. Therefore I need to transpose the data. My problem is that the list of names refers to a master sheet with names and addresses, set out conventionally. The list of names is sorted alphabetically and changes with additions and deletions. Is there a quick way to arrange that cell C4 on the current worksheet = A3 on the master sheet then D4 = A4, E4 = A5, F4 = A6 etc. without having to insert each value one at a time Barry |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose problem
Many thanks. All solutions work well.
Barry "Shane Devenshire" wrote: Hi, You can use =OFFSET(Sheet2!$A$2,COLUMN(A1),0) or =INDEX(Sheet2!$A$3:$A$19,COLUMN(A1)) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Barry Lennox" wrote in message ... I have a spreadsheet with names in column A and dates along row 4. I now realise that the maximum number of names I will have will be 100 to 150 but over say 10 years there will be 2500 t0 3000 dates. Therefore I need to transpose the data. My problem is that the list of names refers to a master sheet with names and addresses, set out conventionally. The list of names is sorted alphabetically and changes with additions and deletions. Is there a quick way to arrange that cell C4 on the current worksheet = A3 on the master sheet then D4 = A4, E4 = A5, F4 = A6 etc. without having to insert each value one at a time Barry |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose problem
Many thanks. It works well
Barry "Pecoflyer" wrote: In C4 enter Code: -------------------- =indirect("mastersheet!a"&column()) -------------------- and drag to the right -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=47395 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transpose - array problem | Excel Discussion (Misc queries) | |||
Problem with transpose function | Excel Discussion (Misc queries) | |||
Transpose Problem | Excel Discussion (Misc queries) | |||
Not exactly a transpose problem | Excel Discussion (Misc queries) | |||
Transpose Problem | Excel Discussion (Misc queries) |