Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
creating transpore
pls help.
i have a excel sheet with code 1 code 2 code 3 description amount 1 amount 2 amount 3 15000 25000 35000 guest 1000 150 1150 i need result 15000 guest 1000 25000 guest 150 35000 guest 1150 -- thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
creating transpore
Assume source data as posted is in Sheet1,
in cols A to G, data from row 2 down In another sheet, put in A2: =OFFSET(Sheet1!$A$2,INT((ROWS($1:1)-1)/3),MOD(ROWS($1:1)-1,3)) B2: =OFFSET(Sheet1!$D$2,INT((ROWS($1:1)-1)/3),) C2: =OFFSET(Sheet1!$E$2,INT((ROWS($1:1)-1)/3),MOD(ROWS($1:1)-1,3)) Select A2:C2, copy down as far as required to transform it exactly as required Success ? Celebrate it here, click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "greg" wrote: i have a excel sheet with code 1 code 2 code 3 description amount 1 amount 2 amount 3 15000 25000 35000 guest 1000 150 1150 i need result 15000 guest 1000 25000 guest 150 35000 guest 1150 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating Yes,No | Excel Discussion (Misc queries) | |||
Creating IF with OR | Excel Worksheet Functions | |||
creating a pdf | Excel Discussion (Misc queries) | |||
Creating Id | Excel Worksheet Functions | |||
Creating | Excel Discussion (Misc queries) |