You have a long data in vertical line.. you want it in vertical line.

Do what select all the data. Press Ctrl + c now select cell from where you want it to appear in horizontal way. Right click your mouse.. select paste special then click transpose and here we go ..:))


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: