Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Make a table"
I have a list (something like this):
aaa=2 ddd=3 ttt=4 ooo=6 aaa=4 ddd=5 ttt=6 ooo=7 aaa=3 ddd=5 ttt=7 ooo=3 .... And I wanto to make something like this aaa ddd ttt ooo 2 3 4 6 4 5 6 7 3 5 7 3 .... how can I do this? Rodrigo Ferreira |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Make a table"
Hi Rodrigo
Copy A1:A4, move cursor to C1, Paste SpecialTranspose In cell C2 enter =OFFSET($B$1,((ROW()-2)*4)+(COLUMN()-3),0) copy across through D2:F2 Copy C2:F2 down as far as required -- Regards Roger Govier "Rodrigo Ferreira" wrote in message ... I have a list (something like this): aaa=2 ddd=3 ttt=4 ooo=6 aaa=4 ddd=5 ttt=6 ooo=7 aaa=3 ddd=5 ttt=7 ooo=3 ... And I wanto to make something like this aaa ddd ttt ooo 2 3 4 6 4 5 6 7 3 5 7 3 ... how can I do this? Rodrigo Ferreira |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Make a table"
Great.
But I still have a problem. Sometimes, some lines doesn't have one parameter: ddd=3 ttt=4 -- Line not exist ooo=6 aaa=4 ddd=5 ttt=6 ooo=7 aaa=3 ddd=5 ttt=7 ooo=3 .... Other problem: Now I have the table: aaa ddd ttt ooo 2 3 4 6 4 5 6 7 3 5 7 3 And I have to return like the first: ddd=3 ttt=4 ooo=6 aaa=4 ddd=5 ttt=6 ooo=7 aaa=3 ddd=5 ttt=7 ooo=3 How can I do this? Rodrigo Ferreira "Roger Govier" escreveu na mensagem ... Hi Rodrigo Copy A1:A4, move cursor to C1, Paste SpecialTranspose In cell C2 enter =OFFSET($B$1,((ROW()-2)*4)+(COLUMN()-3),0) copy across through D2:F2 Copy C2:F2 down as far as required -- Regards Roger Govier "Rodrigo Ferreira" wrote in message ... I have a list (something like this): aaa=2 ddd=3 ttt=4 ooo=6 aaa=4 ddd=5 ttt=6 ooo=7 aaa=3 ddd=5 ttt=7 ooo=3 ... And I wanto to make something like this aaa ddd ttt ooo 2 3 4 6 4 5 6 7 3 5 7 3 ... how can I do this? Rodrigo Ferreira |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Make a table"
One way for your "other" problem ..
Assume table below is in Sheet1 in A1:D4 aaa ddd ttt ooo 2 3 4 6 4 5 6 7 3 5 7 3 In another sheet, Put in A1: =OFFSET(Sheet1!$A$1,,MOD(ROW(A1)-1,4)) Put in B1: =OFFSET(Sheet1!$A$2,INT((ROW(A1)-1)/4),MOD(ROW(A1)-1,4)) Select A1:B1, fill down until zeros appear in col B, signalling exhaustion of data extract. This will yield in A1:B12 the required results: aaa 2 ddd 3 ttt 4 ooo 6 aaa 4 ddd 5 ttt 6 ooo 7 aaa 3 ddd 5 ttt 7 ooo 3 Adapt to suit .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Rodrigo Ferreira" wrote in message ... .... Other problem: Now I have the table: aaa ddd ttt ooo 2 3 4 6 4 5 6 7 3 5 7 3 And I have to return like the first: ddd=3 ttt=4 ooo=6 aaa=4 ddd=5 ttt=6 ooo=7 aaa=3 ddd=5 ttt=7 ooo=3 How can I do this? Rodrigo Ferreira |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a function like "Data Table" for multiple Inputs | Excel Worksheet Functions |