Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal Data to Vertical Data
my data table,
Act id Lab Car SF Mas 1 2 3 4 6 2 6 3 5 8 10 5 7 4 6 how can i make a FORMULA for the above table to be like this, Actid 1 Lab 2 1 Car 3 1 SF 4 1 Mas 6 2 Lab 6 2 Car 3 2 SF 5 2 Mas 8 10 Lab 5 10 Car 7 10 SF 4 10 Mas 6 i know how to do it by copying and transpose, what i need is a formula.... pls. help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal Data to Vertical Data
what im looking is a formula to find the 3rd column. 1st & 2nd column is a
manual entry. "EricBB" wrote: my data table, Act id Lab Car SF Mas 1 2 3 4 6 2 6 3 5 8 10 5 7 4 6 how can i make a FORMULA for the above table to be like this, Actid 1 Lab 2 1 Car 3 1 SF 4 1 Mas 6 2 Lab 6 2 Car 3 2 SF 5 2 Mas 8 10 Lab 5 10 Car 7 10 SF 4 10 Mas 6 i know how to do it by copying and transpose, what i need is a formula.... pls. help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal Data to Vertical Data
On another sheet:
In 2nd column: =INDEX(OFFSET(Sheet1!$B$1,0,0,4,4),1,MOD(ROW()-2,5)+1) In 3rd column: =INDEX(OFFSET(Sheet1!$B$1,0,0,4,4),INT((ROW()-1)/5)+2,MOD(ROW()-2,5)+1) and fill them down! Regards, Stefi €žEricBB€ť ezt Ă*rta: what im looking is a formula to find the 3rd column. 1st & 2nd column is a manual entry. "EricBB" wrote: my data table, Act id Lab Car SF Mas 1 2 3 4 6 2 6 3 5 8 10 5 7 4 6 how can i make a FORMULA for the above table to be like this, Actid 1 Lab 2 1 Car 3 1 SF 4 1 Mas 6 2 Lab 6 2 Car 3 2 SF 5 2 Mas 8 10 Lab 5 10 Car 7 10 SF 4 10 Mas 6 i know how to do it by copying and transpose, what i need is a formula.... pls. help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn vertical data to horizontal data automaticaly | Excel Worksheet Functions | |||
Reformattign Data/Converting-Combinign Vertical Data to Horizontal | Excel Worksheet Functions | |||
how do i convert vertical data into horizontal data | Excel Discussion (Misc queries) | |||
transposing vertical data to horizontal with varying amount of data | Excel Discussion (Misc queries) | |||
How to make Horizontal data go Vertical | Excel Worksheet Functions |