Transposing address data

SueMe January 28, 2009 at 01:21:07
Specs: Windows Vista
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?

See More: Transposing address data

Report •


#1
January 28, 2009 at 07:47:18
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


Report •

#2
January 28, 2009 at 08:07:08
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


Report •

#3
January 28, 2009 at 08:11:25
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


Report •

Related Solutions


Ask Question