Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column To Rows
I often get lists of contacts that are generated in one long column. They are
often may be 4 or 5 rows per record. In order to be able to use the data I need to transpose the rows in each record (one column) to new columns. It may include Company Name in Row A1 and contact name in Row B1 and perhaps Phone or Web Site in C1 etc. The records are always the same amount of rows. I have tried copy, transpose, and text to rows and anything else I can think of. Can anyone make a suggestion ?? Thanks in advance Tony Pass |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count all rows in column with data, Except rows 1-5 | Excel Worksheet Functions | |||
lock column size for some rows and resize for other rows. | Excel Discussion (Misc queries) | |||
printing issue - want to repeat two rows and also 5 rows in column | Excel Discussion (Misc queries) | |||
after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) |