{"id":14822,"date":"2022-10-09T07:10:02","date_gmt":"2022-10-09T01:40:02","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/"},"modified":"2022-10-09T07:10:02","modified_gmt":"2022-10-09T01:40:02","slug":"solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/","title":{"rendered":"[Solved] Excel VBA &#8211; Concatenate Rows with duplicate KEY values [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-25626581\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"25626581\" data-parentid=\"25624499\" data-score=\"1\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" 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>This is the method I described in my comment above:<\/p>\n<blockquote>\n<p>I would probably look at iteration over the rows, building a delimited string (comma or tab delimited) to represent each &#8220;row&#8221; in the formatted output, based on the ID, and then write that out to a TXT file that could easily be read by SPSS<\/p>\n<\/blockquote>\n<p>Here&#8217;s the code. It is slightly more than the 30 lines I estimated \ud83d\ude42<\/p>\n<pre><code>Sub FormatDataFileForSPSS()\nDim rng As Range            'the range representing the entire set of data to be formatted\nDim r As Range              'row iterator for the data table\nDim key As Variant          'id number\nDim rowData As String       'concatenated row data\nDim outputPath As String    'the place to put the output file\nDim outputFile As String    'the file name\n\n'--- REQUIRES REFERENCE TO MICROSOFT SCRIPTING RUNTIME ---\nDim dict As Scripting.Dictionary 'a dictionary that we will use to concat each row by ID\nDim fso As Scripting.FileSystemObject 'used to write the output file\n\n'Begin procedure here...\n\n'Allow the user to select a range of data to format\n' do NOT select the \"header\" row!\nSet rng = Application.InputBox(\"Select the data to be formatted\", \"Select Data\", Type:=8)\n\n'Create the dictionary:\nSet dict = CreateObject(\"Scripting.Dictionary\")\n\n'get the destination for the output file:\noutputPath = CreateObject(\"Wscript.Shell\").SpecialFolders(\"Desktop\") 'Or modify to use a different filepath\noutputFile = outputPath &amp; \"\\my output.txt\" 'Modify as needed\n\n'Iterate the data table:\nFor Each r In rng.Rows\n    'get the key value\n    key = r.Cells(1, 1).Value\n    'Concatenate the row data to a string\n    rowData = r.Cells(1, 2) &amp; vbTab &amp; r.Cells(1, 3) &amp; vbTab &amp; r.Cells(1, 4) &amp; vbTab &amp; r.Cells(1, 5)\n    'Check if this KEY value already exists\n    If Not dict.Exists(key) Then\n        'if not, then add it to the dictionary\n        dict.Add key, rowData\n    Else:\n        'Append to the existing key's value:\n        dict(key) = dict(key) &amp; vbTab &amp; rowData\n    End If\nNext\n\n'Create our FileSystemObject to write the text file:\nSet fso = CreateObject(\"Scripting.FileSystemObject\")\nWith fso.CreateTextFile(Filename:=outputFile, overwrite:=True, unicode:=False)\n    For Each key In dict.Keys\n        .WriteLine dict(key)\n    Next\n    .Close\nEnd With\n\nEnd Sub\n<\/code><\/pre>\n<p>Output as tab-delimited, without header row (since the headers in your example aren&#8217;t unique to begin with).  I am fairly certain that you can specify in SPSS to import the data without header row, and it will assign default variable names that you can later modify if needed.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/10\/Solved-Excel-VBA-Concatenate-Rows-with-duplicate-KEY-values.png\" alt=\"enter image description here\"><\/p>\n<p>Here is the data when viewed in SPSS (follow prompts to open delimited text file)<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/10\/1665279602_142_Solved-Excel-VBA-Concatenate-Rows-with-duplicate-KEY-values.png\" alt=\"enter image description here\"><\/p>\n<p>Or you can open the TXT delmited file in Excel and follow a few prompts, specifying it as Tab-delimited, then you could add the header information in the Excel file:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/10\/1665279602_627_Solved-Excel-VBA-Concatenate-Rows-with-duplicate-KEY-values.png\" alt=\"enter image description here\"><\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">2<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Excel VBA &#8211; Concatenate Rows with duplicate KEY values [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] This is the method I described in my comment above: I would probably look at iteration over the rows, building a delimited string (comma or tab delimited) to represent each &#8220;row&#8221; in the formatted output, based on the ID, and then write that out to a TXT file that could easily be read by &#8230; <a title=\"[Solved] Excel VBA &#8211; Concatenate Rows with duplicate KEY values [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/\" aria-label=\"More on [Solved] Excel VBA &#8211; Concatenate Rows with duplicate KEY values [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":[400,3857,401],"class_list":["post-14822","post","type-post","status-publish","format-standard","hentry","category-solved","tag-excel","tag-spss","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>[Solved] Excel VBA - Concatenate Rows with duplicate KEY values [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-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Excel VBA - Concatenate Rows with duplicate KEY values [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] This is the method I described in my comment above: I would probably look at iteration over the rows, building a delimited string (comma or tab delimited) to represent each &#8220;row&#8221; in the formatted output, based on the ID, and then write that out to a TXT file that could easily be read by ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-09T01:40:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/10\/Solved-Excel-VBA-Concatenate-Rows-with-duplicate-KEY-values.png\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\\\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/person\\\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Excel VBA &#8211; Concatenate Rows with duplicate KEY values [closed]\",\"datePublished\":\"2022-10-09T01:40:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\\\/\"},\"wordCount\":186,\"publisher\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/Solved-Excel-VBA-Concatenate-Rows-with-duplicate-KEY-values.png\",\"keywords\":[\"excel\",\"spss\",\"vba\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\\\/\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\\\/\",\"name\":\"[Solved] Excel VBA - Concatenate Rows with duplicate KEY values [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/Solved-Excel-VBA-Concatenate-Rows-with-duplicate-KEY-values.png\",\"datePublished\":\"2022-10-09T01:40:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\\\/#primaryimage\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/Solved-Excel-VBA-Concatenate-Rows-with-duplicate-KEY-values.png\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/Solved-Excel-VBA-Concatenate-Rows-with-duplicate-KEY-values.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Excel VBA &#8211; Concatenate Rows with duplicate KEY values [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\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777613206\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777613206\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777613206\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\\\/\\\/jassweb.com\"],\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/author\\\/jaspritsinghghumangmail-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Excel VBA - Concatenate Rows with duplicate KEY values [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-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Excel VBA - Concatenate Rows with duplicate KEY values [closed] - JassWeb","og_description":"[ad_1] This is the method I described in my comment above: I would probably look at iteration over the rows, building a delimited string (comma or tab delimited) to represent each &#8220;row&#8221; in the formatted output, based on the ID, and then write that out to a TXT file that could easily be read by ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/","og_site_name":"JassWeb","article_published_time":"2022-10-09T01:40:02+00:00","og_image":[{"url":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/10\/Solved-Excel-VBA-Concatenate-Rows-with-duplicate-KEY-values.png","type":"","width":"","height":""}],"author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Excel VBA &#8211; Concatenate Rows with duplicate KEY values [closed]","datePublished":"2022-10-09T01:40:02+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/"},"wordCount":186,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"image":{"@id":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/#primaryimage"},"thumbnailUrl":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/10\/Solved-Excel-VBA-Concatenate-Rows-with-duplicate-KEY-values.png","keywords":["excel","spss","vba"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/","name":"[Solved] Excel VBA - Concatenate Rows with duplicate KEY values [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"primaryImageOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/#primaryimage"},"image":{"@id":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/#primaryimage"},"thumbnailUrl":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/10\/Solved-Excel-VBA-Concatenate-Rows-with-duplicate-KEY-values.png","datePublished":"2022-10-09T01:40:02+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/#primaryimage","url":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/10\/Solved-Excel-VBA-Concatenate-Rows-with-duplicate-KEY-values.png","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/10\/Solved-Excel-VBA-Concatenate-Rows-with-duplicate-KEY-values.png"},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-excel-vba-concatenate-rows-with-duplicate-key-values-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Excel VBA &#8211; Concatenate Rows with duplicate KEY values [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\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777613206","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777613206","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777613206","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\/14822","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=14822"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/14822\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=14822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=14822"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=14822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}