{"id":7776,"date":"2017-06-27T13:31:59","date_gmt":"2017-06-27T13:31:59","guid":{"rendered":"http:\/\/www.nurturetechacademy.in\/?p=7776"},"modified":"2017-06-27T13:31:59","modified_gmt":"2017-06-27T13:31:59","slug":"sort-data-row-wise-excel","status":"publish","type":"post","link":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/sort-data-row-wise-excel\/","title":{"rendered":"Sort Data Row-Wise in Excel"},"content":{"rendered":"

We have been using Sort function for so long in our work but still one of the most unexplored feature of this function is that we can sort data row wise also. This could be useful in some cases, where our data is in horizontal manner. So let\u2019s see how we can do it\u2026..<\/p>\n

I have created a dummy data for this:<\/p>\n

 <\/p>\n

\"1\"<\/p>\n

 <\/p>\n

First we need to select the data<\/p>\n

 <\/p>\n

\"2\"<\/p>\n

 <\/p>\n

And then go to Data -> Sort<\/p>\n

 <\/p>\n

\"3\"<\/p>\n

 <\/p>\n

Then a Sort dialog box will appear. In this box first click on Options.. and choose Sort left to right instead of top to bottom and then press OK.<\/p>\n

 <\/p>\n

\"4\"<\/p>\n

 <\/p>\n

Now from the dropdown in the box choose your desired row and choose order and then press OK.<\/p>\n

 <\/p>\n

\"5\"<\/p>\n

 <\/p>\n

\"6\"<\/p>\n

 <\/p>\n

And we are done\u2026. \ud83d\ude42<\/p>\n

 <\/p>\n

If you like the this post then don’t forget to subscribe this blog and post your comments.<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

We have been using Sort function for so long in our work but still one of the most unexplored feature of this function is that we can sort data row wise also. This could be useful in some cases, where <\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":7783,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[56],"tags":[57,238,236,237],"class_list":["post-7776","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-excel","tag-sort","tag-tips","tag-tricks"],"_links":{"self":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/7776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/comments?post=7776"}],"version-history":[{"count":1,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/7776\/revisions"}],"predecessor-version":[{"id":7784,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/7776\/revisions\/7784"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media\/7783"}],"wp:attachment":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media?parent=7776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/categories?post=7776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/tags?post=7776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}