Excel Moving data from one line to another

C

cam mcfadden

Joined
Dec 30, 2017
Messages
1
Reaction score
0
I have a excel document that i want to try to condense. right now the documents looks like:

Usar Rd
32000-38000 1 5
Tabor Ln
22 23


is what im looking to do is put the road the address range and page numbers all on to the same line. an example of another road is tabor ln in which there is no address range but associated page numbers.

is there a way to auto do this in excel or I could export it to another format and do it too. there is roughly 70000 lines so I would rather not have to go in and do this by hand.

thanks in advance for those who are smarter than me

cameron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
How to unlink TOC from a doc 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Help to copy information from one row at a time to another sheet 1
moving data from one sheet to another 1
Best method / software for graphical output from dynamic excel data 0
Excel Excel 2010 take data from one spreadsheet to paste to another 1
Extracting House Numbers from Street Addresses 4

Top