| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Record information is on two lines
I have an EXCEL SS with information as follows;
Record 1: A1, B1, C1, D1, A2, B2, C2 Record 2: A3, B3, C3, D3, A4, B4, C4 I would like to fix so each record is on one line: Record 1: A1, B1, C1, D1, E1, F1, G1 etc..... Thanks for any help! |
|
#2
|
|||
|
|||
|
Record information is on two lines
Use a method such as one at the link (see "vertical to horizontal...")
http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy VBA Project Manager www.OfficeArticles.com "Dan" wrote in message oups.com... I have an EXCEL SS with information as follows; Record 1: A1, B1, C1, D1, A2, B2, C2 Record 2: A3, B3, C3, D3, A4, B4, C4 I would like to fix so each record is on one line: Record 1: A1, B1, C1, D1, E1, F1, G1 etc..... Thanks for any help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose rows to columns w/varying numbers of lines per record | Excel Worksheet Functions | |||
| How to delete duplicated records. Each record has four lines | Excel Discussion (Misc queries) | |||
| Clearing information in certain columns | Excel Discussion (Misc queries) | |||
| lookup information in a row like a record | Excel Worksheet Functions | |||
| How do I find a template to record client information? | Excel Discussion (Misc queries) | |||
Linear Mode
