{"id":179516,"date":"2019-01-11T16:03:29","date_gmt":"2019-01-11T21:03:29","guid":{"rendered":"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/"},"modified":"2019-01-11T16:03:29","modified_gmt":"2019-01-11T21:03:29","slug":"how-to-add-a-column-from-an-example-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/","title":{"rendered":"How To Add A Column From an Example In Microsoft Excel"},"content":{"rendered":"

[youtube https:\/\/www.youtube.com\/watch?v=WMcwTBKPrzo?list=PL66F62F9E936D9077]Microsoft Excel has been around for ages. However, did you know that there are a whole host of functionality features to simplify your workflow and help you save time? One of the most commonly used tools is the\u00a0Add Column from Example<\/em>\u00a0option. Here\u2019s what you need to know about it.<\/p>\n

How Do You Add a Column from an Example in Microsoft Excel?<\/strong><\/p>\n

Start by selecting\u00a0Query > Edit<\/em>. Then select\u00a0Add a Column<\/em>. Choose\u00a0Column from Examples<\/em>\u00a0and\u00a0From All Columns<\/em>. After a column is populated, go ahead and add sample data for the new column. Press the\u00a0Ctrl + Enter<\/em>\u00a0keys to instruct Excel to populate the remaining fields.<\/p>\n

When is Adding a Column from an Example in Microsoft Excel Useful?<\/strong><\/p>\n

The Add Column from Example feature is an instrumental part of Microsoft Excel\u2019s Power Query functionality that saves users an immense amount of time. Examples of an ideal time to use this function in situations where you need a column that references another column, such as when you want to join two columns together. For example, combining city and state names together for an address.<\/p>\n

\"Microsoft<\/p>\n

Is Add Column from Example a Feature for All Versions of Microsoft Excel?<\/strong><\/p>\n

Unfortunately, the Power Query feature of Microsoft Excel is a relatively new addition to the popular software program. You must have Excel 2016 or Office 360 to use it unless you install a free add-in from\u00a0Microsoft<\/a>\u00a0to your version,<\/p>\n

In short, the\u00a0Add Column from Example<\/em>\u00a0feature is a practical and useful way to clean up data sets without additional time or effort.<\/p>\n","protected":false},"excerpt":{"rendered":"

[youtube https:\/\/www.youtube.com\/watch?v=WMcwTBKPrzo?list=PL66F62F9E936D9077]Microsoft Excel has been around for ages. However, did you know that there are a whole host of functionality features to simplify your workflow and help you save time? One of the most commonly used tools is the\u00a0Add Column from Example\u00a0option. Here\u2019s what you need to know about it. How Do You Add a…<\/p>\n","protected":false},"author":5,"featured_media":159061,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[8],"tags":[64],"class_list":["post-179516","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-techbytes"],"acf":[],"yoast_head":"\nHow To Add A Column From an Example In Microsoft Excel - IT Services in Virginia<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Add A Column From an Example In Microsoft Excel - IT Services in Virginia\" \/>\n<meta property=\"og:description\" content=\"[youtube https:\/\/www.youtube.com\/watch?v=WMcwTBKPrzo?list=PL66F62F9E936D9077]Microsoft Excel has been around for ages. However, did you know that there are a whole host of functionality features to simplify your workflow and help you save time? One of the most commonly used tools is the\u00a0Add Column from Example\u00a0option. Here\u2019s what you need to know about it. How Do You Add a…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"IT Services in Virginia\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-11T21:03:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.ntegrait.com\/wp-content\/uploads\/2019\/01\/GettyImages-881365070.jpg\" \/>\n<meta name=\"author\" content=\"Steve West\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Steve West\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/\",\"url\":\"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/\",\"name\":\"How To Add A Column From an Example In Microsoft Excel - IT Services in Virginia\",\"isPartOf\":{\"@id\":\"https:\/\/www.ntegrait.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/ntegrait.com\/wp-content\/uploads\/2019\/01\/GettyImages-881365070.jpg\",\"datePublished\":\"2019-01-11T21:03:29+00:00\",\"dateModified\":\"2019-01-11T21:03:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.ntegrait.com\/#\/schema\/person\/33156c118f002b88019c3fc70441bf79\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/#primaryimage\",\"url\":\"https:\/\/ntegrait.com\/wp-content\/uploads\/2019\/01\/GettyImages-881365070.jpg\",\"contentUrl\":\"https:\/\/ntegrait.com\/wp-content\/uploads\/2019\/01\/GettyImages-881365070.jpg\",\"width\":508,\"height\":339},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ntegrait.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Add A Column From an Example In Microsoft Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.ntegrait.com\/#website\",\"url\":\"https:\/\/www.ntegrait.com\/\",\"name\":\"IT Services in Virginia\",\"description\":\"Ntegra IT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.ntegrait.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.ntegrait.com\/#\/schema\/person\/33156c118f002b88019c3fc70441bf79\",\"name\":\"Steve West\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.ntegrait.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cc273f166c78aca895198956663df42?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cc273f166c78aca895198956663df42?s=96&d=mm&r=g\",\"caption\":\"Steve West\"},\"description\":\"Ntegra IT is devoted to providing reliable Computer Support to businesses that want to improve productivity and profitability. We deliver custom designed Network Services that better map to your business, so you can stop worrying about your technology and get back to achieving your business goals.\",\"url\":\"https:\/\/ntegrait.com\/author\/swestntegrait-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Add A Column From an Example In Microsoft Excel - IT Services in Virginia","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/","og_locale":"en_US","og_type":"article","og_title":"How To Add A Column From an Example In Microsoft Excel - IT Services in Virginia","og_description":"[youtube https:\/\/www.youtube.com\/watch?v=WMcwTBKPrzo?list=PL66F62F9E936D9077]Microsoft Excel has been around for ages. However, did you know that there are a whole host of functionality features to simplify your workflow and help you save time? One of the most commonly used tools is the\u00a0Add Column from Example\u00a0option. Here\u2019s what you need to know about it. How Do You Add a…","og_url":"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/","og_site_name":"IT Services in Virginia","article_published_time":"2019-01-11T21:03:29+00:00","og_image":[{"url":"https:\/\/www.ntegrait.com\/wp-content\/uploads\/2019\/01\/GettyImages-881365070.jpg","type":"","width":"","height":""}],"author":"Steve West","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Steve West","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/","url":"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/","name":"How To Add A Column From an Example In Microsoft Excel - IT Services in Virginia","isPartOf":{"@id":"https:\/\/www.ntegrait.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/ntegrait.com\/wp-content\/uploads\/2019\/01\/GettyImages-881365070.jpg","datePublished":"2019-01-11T21:03:29+00:00","dateModified":"2019-01-11T21:03:29+00:00","author":{"@id":"https:\/\/www.ntegrait.com\/#\/schema\/person\/33156c118f002b88019c3fc70441bf79"},"breadcrumb":{"@id":"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/#primaryimage","url":"https:\/\/ntegrait.com\/wp-content\/uploads\/2019\/01\/GettyImages-881365070.jpg","contentUrl":"https:\/\/ntegrait.com\/wp-content\/uploads\/2019\/01\/GettyImages-881365070.jpg","width":508,"height":339},{"@type":"BreadcrumbList","@id":"https:\/\/www.ntegrait.com\/how-to-add-a-column-from-an-example-in-microsoft-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ntegrait.com\/"},{"@type":"ListItem","position":2,"name":"How To Add A Column From an Example In Microsoft Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.ntegrait.com\/#website","url":"https:\/\/www.ntegrait.com\/","name":"IT Services in Virginia","description":"Ntegra IT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.ntegrait.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.ntegrait.com\/#\/schema\/person\/33156c118f002b88019c3fc70441bf79","name":"Steve West","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.ntegrait.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cc273f166c78aca895198956663df42?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cc273f166c78aca895198956663df42?s=96&d=mm&r=g","caption":"Steve West"},"description":"Ntegra IT is devoted to providing reliable Computer Support to businesses that want to improve productivity and profitability. We deliver custom designed Network Services that better map to your business, so you can stop worrying about your technology and get back to achieving your business goals.","url":"https:\/\/ntegrait.com\/author\/swestntegrait-com\/"}]}},"_links":{"self":[{"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/posts\/179516","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/comments?post=179516"}],"version-history":[{"count":0,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/posts\/179516\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/media\/159061"}],"wp:attachment":[{"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/media?parent=179516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/categories?post=179516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/tags?post=179516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}