First of all,  thank you for all the help that I received so far.  You
guys are great.

Today I have the following problem.  I have a file where all the data
is on column A.  The data is listing the name of a person in row 1,
in row 2 and row 3 it list the address.

from the sample below I like to re-arrange the data so row 1 will be
left as is on column A, row 1.   The information on column A, row 2
moves to column B, row 1,  and finally the data on column A, row 3
moves to column C, row 1.   After that the process loops to populate
row 2, row 3, etc, etc.

See below how the data is now

1 7461-001 M Y Y JOSEPH LOPEZ 12 $111.25 01/01/09 $25.00 09
17921 NW 79 CT
MIAMI FL 33015
2 7461-002 M Y Y ESPERANZA DIAZ 12 $111.25 01/01/09 $25.00
7461 NW 175 ST.
MIAMI FL 33015
3 7461-003 M Y Y BERNARDO ARAUJO 12 $111.25 01/01/09 $25.00
7461 NW 176 TERR
MIAMI FL 33015
4 7462-004 M Y Y JUAN AMAT 12 $111.25 01/01/09 $25.00 09 DAY
7462 NW 175 ST.
MIAMI FL 33015

This is how I need it to be

1 7461-001 M Y Y JOSEPH LOPEZ 12 $111.25 01/01/09 $25.00 09 DAYS        17921
NW 79 CT        MIAMI FL 33015
2 7461-002 M Y Y ESPERANZA DIAZ 12 $111.25 01/01/09 $25.00 09 DAYS
7461 NW 175 ST. MIAMI FL 33015
3 7461-003 M Y Y BERNARDO ARAUJO 12 $111.25 01/01/09 $25.00 09 DAYS
7461 NW 176 TERR        MIAMI FL 33015
4 7462-004 M Y Y JUAN AMAT 12 $111.25 01/01/09 $25.00 09 DAYS   7462 NW
175 ST. MIAMI FL 33015


I have attached a sample file for illustrations.  On sheet 1 is the
original file, and on sheet 2 is how I need to file to be.   Notice
that you will be able to identify the first row of each record because
it contains a numerical indicator starting a 1.  In other words.  1
space, 2 space, 3 space, 4 space, etc, etc.

I am sending a file with the name extract-address.xls

Thank you in advance for all the help

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to