Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a table with vertical dimensions of pipes and thickness of pipes
horizontally as below. NPS OD CIRCM 25 30 35 40 45 50 55 3 4 5 6 7 8 9 10 0.125 10.3 0.01 0.2 0.2 0.3 0.3 0.3 0.3 0.4 0.25 13.7 0.01 0.2 0.2 0.3 0.3 0.3 0.4 0.4 0.375 17.1 0.02 0.2 0.2 0.3 0.3 0.3 0.4 0.4 0.5 21.3 0.02 0.2 0.3 0.3 0.3 0.3 0.4 0.4 0.75 26.7 0.03 0.2 0.3 0.3 0.3 0.4 0.4 0.4 1 33.4 0.03 0.3 0.3 0.3 0.4 0.4 0.4 0.5 That is, vertically from row 1 to 8 and horizontally from column a to j I need the result in other sheet NPS THK WEIGHT 0.125 25 ? 0.25 25 ? 0.375 30 ? 0.5 35 ? 0.75 40 ? 1 45 ? Please advice is it possible and how if possible. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I arrange tabs vertically in Excel (not horizontally)? | Excel Discussion (Misc queries) | |||
Can't drag to align shapes vertically or horizontally | Excel Discussion (Misc queries) | |||
how to search vertically then count horizontally in excel | Excel Worksheet Functions | |||
extending a horizontally calculated formula vertically | Excel Discussion (Misc queries) | |||
Move cells vertically to horizontally | Excel Discussion (Misc queries) |