Excel Macro To Move Data Horizontally from Vertically Organized....

Ok, so I have a list of customers organized in vertical format (don't ask, they came that way).. Anyway, each customer has (9) cells of data on them. So basically A1 is NAME, A2 is TYPE, A3 is ADD1, A4 is ADD2, A5 is CONTACT, A6 is TITLE, A7 is EMAIL, A8 is PHONE, A9 is FAX. Now, from what I gather, every contact has the same amount of data.. so, A1-A9 is customer 1, A10-A18 is customer 2, A19-27, and so on.. So, multiples of 9 here.


What macro would do this for me..? Take 9 cells, lay them horizontally in A1, then go to A10-A18, lay horizontally, etc... I can deal with all the blank rows in the end if need be, but I just want to figure out how to do this...

Thanks!

Also, on another note.. I find myself coming here trying to figure this stuff out on my own.. and this is something that we'll probably be doing relatively frequently... Is there a freelance position that would handle this..? Would it be a database person?

Thanks again!

Try this code

Please Login or Register  to view this content.

Results will be in Column B as start point
After that you can delete column A and blank rows ..

Use this code to delete column A and balnk rows

Please Login or Register  to view this content.

Awesome! Thanks.. All the way from Egypt! ;c) Turns out the data isn't exactly uniform after all.. I'm wondering.. Is there a way to have the code use the cell in CAPS as an identifier of the new line of data? Know what I mean?

Can you post a sample workbook?

Hey Stephen,
I actually got it figured out, by simply running the code until I found the error (8 instead of 9 rows to an entry, etc)... Thank you for offering your assistance though! I almost would post a sample here to simply figure out how to do it... Here is what I was trying to do

NAME
cell1
cell2
cell3
cell4
cell5
NAME
cell1
cell2
cell3
NAME
cell1
cell2
cell3
cell4

I wanted to be able to separate each entry, starting with the CAPS as the identifier of a new entry. I wonder if this is enough info..?

Code could search for upper case specifically if required.