Hi ... I'm not terrific with excel and wonder if anyone can help me. I am using excel 2002. I have many thousands of three-row addresses (a1=Name, a2=address1, a3=address2). I would like to turn them into column data for export to Access. So a1=name, b1=address1, c1=address2 and so on for thousands and thousands of rows. Any ideas how I can automate the process please?

Is all the data in the first three rows of the spreadsheet? So, in A1 you have a name and in B1 you have another name, and so on? "So won’t you give this man his wings What a shame To have to beg you to see We’re not all the same What a shame" - Shinedown

Highlight the data then go to Paste > Special Down the bottom is a check box for Transpose Make sure you don't overlap the cells or you get an error message. MIKE

If you're using 2007, use Paste, Transpose, not Paste Special. "So won’t you give this man his wings What a shame To have to beg you to see We’re not all the same What a shame" - Shinedown