Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose from Col to row
Hi,
I have one large sheet call a.xls which has data going down the column. e.g Hr target 8 10 9 12 11 9 12 15 14 20 Another worksheet on seperate workbook - calls b.xls, basic on matched data - hour, to transpose on to. The layout on the b.xls look like this between hr 8 - 9 9 - 10 10 - 11 11 - 12 12 - 13 13 - 14 Target 10 12 15 20 The 10, 12, 15 and 20 on the Target of b.xls is from a.xls If there is no matching data between a.xls and b.xls on the hour, just leave the field blank on b.xls How can I do this please ? Many thanks, Rach |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need transpose? help.... | Excel Worksheet Functions | |||
Transpose? | Excel Worksheet Functions | |||
Help using Transpose | Excel Discussion (Misc queries) | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
Transpose | Excel Programming |