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