Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Columns to Rows
Very simple but would save me a hell of a lot of copy and pasting.
Ive got a spreadsheet that has a list of names in each column. i.e. Col A has Rob in rows 1-4, B has Cesc in 1-4, C has Robin in 1-4, D has Gael in 1-4 etc. I need to see these in a single column. So, row E will become Rob in E1 - E4, Cesc in E5-E8, Robin in E9-E12 and Gael in E13 - E16 Many thanks to any genuis that can help me.. Rob -- Rob Gaffney |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) |