{"id":3926,"date":"2022-08-21T00:05:38","date_gmt":"2022-08-20T18:35:38","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/"},"modified":"2022-08-21T00:05:38","modified_gmt":"2022-08-20T18:35:38","slug":"solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/","title":{"rendered":"(Solved) How do I transpose a set of columns and save the output as a CSV [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-32262807\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"32262807\" data-parentid=\"32262575\" data-score=\"0\" data-position-on-page=\"2\" data-highest-scored=\"0\" data-question-has-accepted-highest-score=\"0\" itemprop=\"suggestedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>You take some code to export to CSV, such as from this answer<br \/>\nHow to create a separate CSV file from VBA?<br \/>\nand just change the order you write to the file. E.g. write the column before writing the row<\/p>\n<pre><code>Sub WriteFile()\n\n  Dim ColNum As Integer\n  Dim Line As String\n  Dim LineValues() As Variant\n  Dim OutputFileNum As Integer\n  Dim PathName As String\n  Dim RowNum As Integer\n  Dim SheetValues() As Variant\n\n  PathName = Application.ActiveWorkbook.Path\n  OutputFileNum = FreeFile\n\n  Open PathName &amp; \"\\Test.csv\" For Output Lock Write As #OutputFileNum\n\n  'Print #OutputFileNum, \"Field1\" &amp; \",\" &amp; \"Field2\"\n\n  SheetValues = Sheets(\"RawData\").Range(\"A1:C249\").Value\n\nDim RowMax\nRowMax = UBound(SheetValues)\nDim ColMax\nColMax = 3\nReDim LineValues(1 To RowMax)\n\n  For ColNum = 1 To ColMax\n    For RowNum = 1 To RowMax\n      LineValues(RowNum) = SheetValues(RowNum, ColNum)\n    Next\n    Line = Join(LineValues, \",\")\n    Print #OutputFileNum, Line\n  Next\n\n  Close OutputFileNum\n\nEnd Sub\n<\/code><\/pre>\n<p>Hopefully that is a good enough to get you going.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved How do I transpose a set of columns and save the output as a CSV [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] You take some code to export to CSV, such as from this answer How to create a separate CSV file from VBA? and just change the order you write to the file. E.g. write the column before writing the row Sub WriteFile() Dim ColNum As Integer Dim Line As String Dim LineValues() As Variant &#8230; <a title=\"(Solved) How do I transpose a set of columns and save the output as a CSV [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/\" aria-label=\"More on (Solved) How do I transpose a set of columns and save the output as a CSV [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[483,400,401],"class_list":["post-3926","post","type-post","status-publish","format-standard","hentry","category-solved","tag-csv","tag-excel","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>(Solved) How do I transpose a set of columns and save the output as a CSV [closed] - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"(Solved) How do I transpose a set of columns and save the output as a CSV [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] You take some code to export to CSV, such as from this answer How to create a separate CSV file from VBA? and just change the order you write to the file. E.g. write the column before writing the row Sub WriteFile() Dim ColNum As Integer Dim Line As String Dim LineValues() As Variant ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-20T18:35:38+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\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\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"(Solved) How do I transpose a set of columns and save the output as a CSV [closed]\",\"datePublished\":\"2022-08-20T18:35:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/\"},\"wordCount\":87,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"csv\",\"excel\",\"vba\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/\",\"name\":\"(Solved) How do I transpose a set of columns and save the output as a CSV [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-08-20T18:35:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"(Solved) How do I transpose a set of columns and save the output as a CSV [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"(Solved) How do I transpose a set of columns and save the output as a CSV [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/","og_locale":"en_US","og_type":"article","og_title":"(Solved) How do I transpose a set of columns and save the output as a CSV [closed] - JassWeb","og_description":"[ad_1] You take some code to export to CSV, such as from this answer How to create a separate CSV file from VBA? and just change the order you write to the file. E.g. write the column before writing the row Sub WriteFile() Dim ColNum As Integer Dim Line As String Dim LineValues() As Variant ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/","og_site_name":"JassWeb","article_published_time":"2022-08-20T18:35:38+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"(Solved) How do I transpose a set of columns and save the output as a CSV [closed]","datePublished":"2022-08-20T18:35:38+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/"},"wordCount":87,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["csv","excel","vba"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/","name":"(Solved) How do I transpose a set of columns and save the output as a CSV [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-08-20T18:35:38+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-transpose-a-set-of-columns-and-save-the-output-as-a-csv-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"(Solved) How do I transpose a set of columns and save the output as a CSV [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/3926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=3926"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/3926\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=3926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=3926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=3926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}