{"id":15228317,"date":"2022-01-07T13:37:02","date_gmt":"2022-01-07T13:37:02","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/nested-csv\/"},"modified":"2022-01-07T13:37:02","modified_gmt":"2022-01-07T13:37:02","slug":"nested-csv","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/nested-csv\/","title":{"rendered":"Nested CSV"},"content":{"rendered":"<p>I have a csv with a nested format. Basically it&#8217;s like this:<\/p>\n<p>Row 1 has Col A populated. Rows 2-10 don&#8217;t have Col A populated and their information starts in Col B, yet the preceeding Col A is a value of each item.<\/p>\n<p>Eventually Col A will get a new value which apply to the below rows.<\/p>\n<p>This would be like Col A is the company and Col B is people&#8217;s names. All the people whose names are in B1-B10 work for the company listed in A1.<\/p>\n<p>Any way to apply the A1 value to the items in rows 1-10?<\/p>\n<p>Thanks! <a href=\"https:\/\/appliance.report\/\">Appliance Team<\/a><\/p>\n","protected":false},"template":"","class_list":["post-15228317","topic","type-topic","status-publish","hentry","topic-tag-csv","topic-tag-import","topic-tag-nesting"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/15228317","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/15228317\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=15228317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}