Is there an easy way to modify an excel database?

[RachelIp]

I'm using Excel 2010 and I have a list of names and addresses and it's pretty much just like they did it in Word. I need all the names in one column, addresses in another. Is there an easy way to do it because I have 1400 names and that would take many hours.

[Domski]

Possibly but it would really help to see a few examples in a sample workbook to see if there is any logic to the layout of the data.

Dom

[RachelIp]

I don't really have a place to upload the sample but I can show it here

NAME
Address
City
(3 empty cells)
NAME
Address
City
(3 empty cells)

This goes on for 1400 names and I'm moving each cell individually. And I need them to appear like this

Name | Address | City

[Domski]

You can upload files to the forum.

Have a go with this anyway:

Please Login or Register  to view this content.

It will take the addresses from column A and write them to columns E:G.

Dom

[RachelIp]

You'll have to forgive me, but I don't even know how to use code in Excel.

I have been doing them one at a time and I just noticed the format changed.

Now it's
NAME
(1 cell space)
Address
City
(2 cell spaces)
NAME
(1 cell space)
Address
City
(2 cell spaces)

[RachelIp]

I tried the code and I have all the business names in a column, but what about the rest of the information? How do I alter the code to do the rest of the data?

[RachelIp]

NEVER MIND!

I played with the code and accidentally figured out how to get the address and city to list into columns (even though the names didn't come with it)

Please Login or Register  to view this content.

I just changed

lngWriteRow = 1
For lngLoopRow = 1 To Range("A" & Rows.Count).End(xlUp).Row Step 6

to

lngWriteRow = 3
For lngLoopRow = 3 To Range("A" & Rows.Count).End(xlUp).Row Step 6

I want to thank you so much for your help Domski! You were a real life saver!!

[Domski]

Sorry, I left work. It should bring the names. If you need help modifying the code let me know.

Dom

[RachelIp]

It didn't bring the names so all I did was use your code and run the macro a second time to pick it all up.

[RachelIp]

This is a sample of the database I was given

[Domski]

Here you go:

Please Login or Register  to view this content.

Dom

[RachelIp]

That worked! You're a life saver!