ExcelBanter - View Single Post

Bob Umlas, Excel MVP

send me a sample workbook to

"ktfrubel" wrote:

Bob,
Thanks for the advise, however I am not getting the results I need. I keep
getting a bunch of 0's. Could you explain your process a different way?

"Bob Umlas, Excel MVP" wrote:

Assuming your data starts in A1:
Enter a1 in cell B1 (no equal sign), enter a5 in cell B2. select B1, use
fill handle right to E1, then select B2, fill handle to E2.
Now select B1:E2 and use the fill handle down to 1/4 of your data -- if your
data ended in A24, you fill down to E6. If you data ends in A1152, fill down
to E288. Now, select B:E, use edit/replace, replace a with =a and you're
nearly done. Copy B:E, paste special values, delete column A.
Bob Umlas
Excel MVP

modified for you from my book, "This isn't Excel, it's Magic"
http://www.iil.com/iil/excelmagic

"ktfrubel" wrote:

covert an entire spreadsheet from a column format to a row format?

I have a spreadsheet that was given to me that has about 1150 entries. The
format that the came to was:

Name
Address
City State
Zip

The format I need to get is

Name Address CityState Zip

Is there a way to change this in one fast way instead of having to copy
paste special each one?