{"id":12185,"date":"2021-12-09T00:28:54","date_gmt":"2021-12-09T00:28:54","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=12185"},"modified":"2021-12-09T00:29:11","modified_gmt":"2021-12-09T00:29:11","slug":"solved-need-to-combine-two-sheets-and-sort-align-columns-in-excel","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/need-to-combine-two-sheets-and-sort-align-columns-in-excel\/18296.html","title":{"rendered":"Solved Need To Combine Two Sheets And Sort \/ Align Columns In Excel"},"content":{"rendered":"<p>I have two separate excel worksheets &#8211; both have a column which contains a reference number and there are common and unique numbers in both sheets. I need to combine the two sheets and align the two columns so that the rows of data from the second sheet line up with the rows of data from the first using the common policy number. The data in the third column needs to align with the data in the 2nd column so effectively there would be some spaces in the final result.<\/p>\n<p>Policy Number Policy Number Ref<br \/>\n86119946117 86219941732 a<br \/>\n86119700141 66509837115 b<br \/>\n86120463761 86120700505 c<br \/>\n86120166364 86219442365 d<br \/>\n86120705856 65508447920 e<br \/>\n86119459680 86119946117 f<br \/>\n8611025800 86119700141 g<br \/>\n65509155938 86120463761 h<br \/>\n86220712280 86120166364 i<br \/>\n86120206618 86120705856 j<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":36},"question-category":[53],"question_tags":[],"class_list":["post-12185","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/12185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=12185"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=12185"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=12185"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=12185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}