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 | |||
TRANSPOSE 'group' of columns to rows | Excel Discussion (Misc queries) | |||
Help using Transpose | Excel Discussion (Misc queries) | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
transpose a column into many rows | Excel Discussion (Misc queries) | |||
TRANSPOSE() | Excel Worksheet Functions |