ROWS WRaP AROUND

[Guest]

Trying to import a comma delimited file, which I have done several times. This time the file has 2 rows for each name, address, etc. Excel imports as 2 rows, but I need all the names in one column. How can I put 2nd row in import file into one long row in excel

 

[Guest]

Jess

If I read it right your imported file ends up with something like this in the top two rows
A B C D
1 Feet per Tom 432 Elm St Accoun
2 Mile Invoice Hanks Anytown, USA Number

and you want 1A to say Feet per Mile (in this example)

Try this: Insert a blank row below the last row of data you want to combine
In the first column of the new row (A3) enter the worksheet function belo

=CONCATENATE(A1," ",A2

The concatenate function strings together the values in the cells. The " " is so a space goes in between the words. If you leave out that argument, you get 'TomHanks' instead of 'Tom Hanks'. Then copy the formula to the other columns. The Drag Handle works great for copying into long headers. Play with it. Put "Jess" in and see what happens. You can always undo

Then you can copy the concatenated cells and do a Paste Special - Values to get the full name or address in single cells

If you get lost use the F1 help for worksheet functions

Hope it helps. Good Luck!