Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Rajinder
Lv 6
Rajinder asked in Computers & InternetSoftware · 1 decade ago

In Excel moving the contents of Column to rows?

Dear all,

I want to tansfer columns contents of a row so that they display like we type addresses t...ie one line after the other. there are 500 rows how to do it.

Thanks

1 Answer

Relevance
  • ♥♥ Thinking only U ♥♥
    1 decade ago
    Favourite answer

    It seems, you want to change from column view to row view of the data.

    The steps are:

    >copy the column data

    >right click in the desired cell

    >past special

    >click on check transpose button

    >press ok

    Hope this helps u

    Source(s): Own experiance
Still have questions? Get answers by asking now.