{"id":3723,"date":"2015-09-28T12:25:12","date_gmt":"2015-09-28T10:25:12","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3723"},"modified":"2024-02-06T15:45:50","modified_gmt":"2024-02-06T14:45:50","slug":"free-training-transform-erp-report-excel-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-transform-erp-report-excel-pivot-table\/","title":{"rendered":"Data Cleansing Training Bonus Video #2: Transform an ERP Report to an Excel Pivot Table"},"content":{"rendered":"<div style=\"text-align: center;\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-transform-erp-report-excel-pivot-table\/#_The_Ultimate_Excel_Power_Query_Data_Cleansing_Course\" title=\"\u00a0The Ultimate Excel Power Query &amp; Data Cleansing Course \">\u00a0The Ultimate Excel Power Query &amp; Data Cleansing Course <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-transform-erp-report-excel-pivot-table\/#is_Closing_its_Doors_in%E2%80%A6\" title=\"is Closing its Doors\u00a0in&#8230;\">is Closing its Doors\u00a0in&#8230;<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-transform-erp-report-excel-pivot-table\/#_BONUS_VIDEO_2\" title=\"\u00a0BONUS VIDEO #2:\">\u00a0BONUS VIDEO #2:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-transform-erp-report-excel-pivot-table\/#Transform_an_ERP_Report_to_an\" title=\"Transform\u00a0an ERP Report to an \">Transform\u00a0an ERP Report to an <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-transform-erp-report-excel-pivot-table\/#Excel_Pivot_Table_Dashboard\" title=\"Excel Pivot Table Dashboard\">Excel Pivot Table Dashboard<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-transform-erp-report-excel-pivot-table\/#Click_to_view_access_the_course_now\" title=\"Click to view &amp; access the course now:\">Click to view &amp; access the course now:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-transform-erp-report-excel-pivot-table\/#View_Training_Videos_1_2_3_again_before_they_disappear_in\" title=\"View Training Videos 1, 2 &amp; 3 again before they disappear in:\">View Training Videos 1, 2 &amp; 3 again before they disappear in:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-transform-erp-report-excel-pivot-table\/#_NEW_ANNOUNCEMENT\" title=\"*** NEW ANNOUNCEMENT ***\">*** NEW ANNOUNCEMENT ***<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-transform-erp-report-excel-pivot-table\/#Listen_to_Oz_and_I_discuss_data_cleansing_our_upcoming_online_course%E2%80%A6\" title=\"Listen to Oz and I discuss data cleansing &amp;\u00a0our upcoming online course&#8230;\">Listen to Oz and I discuss data cleansing &amp;\u00a0our upcoming online course&#8230;<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-transform-erp-report-excel-pivot-table\/#i\" title=\"\u00a0\">\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-transform-erp-report-excel-pivot-table\/#Please_leave_a_comment_below_if_you_liked_this_video_or_if_you_have_any_questions_and_we_will_reply_back_with_a_fix_%F0%9F%99%82\" title=\"Please leave a comment below if you liked this video or if you have any questions\u00a0and we will reply back with a fix \ud83d\ude42\u00a0\">Please leave a comment below if you liked this video or if you have any questions\u00a0and we will reply back with a fix \ud83d\ude42\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-transform-erp-report-excel-pivot-table\/#make_sure_to_be_specific_and_attach_example_workbook_links_if_possible\" title=\"(make sure to be specific and attach example workbook links if possible)\">(make sure to be specific and attach example workbook links if possible)<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"_The_Ultimate_Excel_Power_Query_Data_Cleansing_Course\"><\/span><strong><span style=\"color: #0000ff;\">\u00a0The Ultimate Excel Power Query &amp; Data Cleansing Course <\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"is_Closing_its_Doors_in%E2%80%A6\"><\/span><strong><span style=\"color: #0000ff;\">is Closing its Doors\u00a0in&#8230;<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<p>&nbsp;<\/p>\n<div class=\"ddio_countdown_wrap\"><\/div>\n<p><a href=\"http:\/\/myexcelonline.thinkific.com\/courses\/power-query-data-cleansing-enroll\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"Data Cleansing Training - Different Ways to Format Data Using Power Query\"  class=\"aligncenter wp-image-4635 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/OzCourse1_728x90.jpg\" alt=\"Data Cleansing Training - Different Ways to Format Data Using Power Query\" width=\"728\" height=\"90\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/OzCourse1_728x90.jpg 728w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/OzCourse1_728x90-300x37.jpg 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/p>\n<hr \/>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"_BONUS_VIDEO_2\"><\/span><span style=\"color: #0000ff;\">\u00a0BONUS VIDEO #2:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Transform_an_ERP_Report_to_an\"><\/span><span style=\"color: #ff0000;\">Transform\u00a0an ERP Report to an <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Excel_Pivot_Table_Dashboard\"><\/span><span style=\"color: #ff0000;\">Excel Pivot Table Dashboard<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<p>&nbsp;<\/p>\n<div class=\"wistia_responsive_padding\" style=\"padding: 56.25% 0 0 0; position: relative;\">\n<div class=\"wistia_responsive_wrapper\" style=\"height: 100%; left: 0; position: absolute; top: 0; width: 100%;\"><iframe class=\"wistia_embed\" src=\"\/\/fast.wistia.net\/embed\/iframe\/5k5njk2vs2?videoFoam=true\" name=\"wistia_embed\" width=\"100%\" height=\"100%\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<\/div>\n<p><script src=\"\/\/fast.wistia.net\/assets\/external\/E-v1.js\" async><\/script><br \/>\n<center><em>In this training you are going to learn the following:<\/em><\/center><center><\/center><center>Intro: Converting Financial Data into a Flat File<br \/>\n<strong>01:00<\/strong> Starting the Solution<br \/>\n<strong>04:50<\/strong> Add Conditional Column in PQ<br \/>\n<strong>07:10<\/strong> Unpivot Other Columns<br \/>\n<strong>08:42<\/strong> Insert <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a><br \/>\n<strong>09:28<\/strong> Insert Slicers<br \/>\n<strong>10:28<\/strong> Intro 2: Pointing to a Dedicated Folder<br \/>\n<strong>16:25<\/strong> Add New File to Dedicated Folder<br \/>\n<strong>17:08<\/strong> Refresh Pivot Table<br \/>\n<strong>17:27<\/strong> Add another File to Dedicated Folder<br \/>\n<strong>18:50<\/strong> A word about Queries, Connections and Filepaths<br \/>\n<strong>20:00<\/strong> Editing the Query<\/center>&nbsp;<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Bonus-Video-2-Workbook.zip\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Bonus-Video-2-Workbook.zip\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download the excel workbooks used in this video <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Bonus-Video-2-Workbook.zip<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Click_to_view_access_the_course_now\"><\/span><span style=\"color: #0000ff;\">Click to view &amp; access the course now:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<p><a href=\"http:\/\/myexcelonline.thinkific.com\/courses\/power-query-data-cleansing-enroll\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"Data Cleansing Training - Different Ways to Format Data Using Power Query\"  class=\"aligncenter wp-image-4635 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/OzCourse1_728x90.jpg\" sizes=\"(max-width: 728px) 100vw, 728px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/OzCourse1_728x90.jpg 728w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/OzCourse1_728x90-300x37.jpg 300w\" alt=\"Data Cleansing Training - Different Ways to Format Data Using Power Query\" width=\"728\" height=\"90\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><\/h3>\n<hr \/>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"View_Training_Videos_1_2_3_again_before_they_disappear_in\"><\/span><span style=\"color: #0000ff;\">View Training Videos 1, 2 &amp; 3 again before they disappear in:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<p>&nbsp;<\/p>\n<div class=\"ddio_countdown_wrap\"><\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div style=\"width: 100%; float: left; display: block; margin-bottom: 40px; margin-top: 40px;\">\n<p style=\"text-align: center; width: 31%; float: left; margin: 5px;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"Data Cleansing Training - Clean &amp; Extract Data Using Formulas &amp; Excel&#039;s Analytical Tools\"  class=\"wp-image-3530 size-medium aligncenter\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/PQ-VIDEO-1-THUMBNAIL-WITH-VIDEO-PLAYER-300x169.png\" alt=\"Data Cleansing Training - Clean &amp; Extract Data Using Formulas &amp; Excel&#039;s Analytical Tools\" width=\"300\" height=\"169\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/PQ-VIDEO-1-THUMBNAIL-WITH-VIDEO-PLAYER-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/PQ-VIDEO-1-THUMBNAIL-WITH-VIDEO-PLAYER-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/PQ-VIDEO-1-THUMBNAIL-WITH-VIDEO-PLAYER-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/PQ-VIDEO-1-THUMBNAIL-WITH-VIDEO-PLAYER.png 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p style=\"text-align: center; width: 31%; float: left; margin: 5px;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/data-cleansing-training-clean-extract-data-using-formulas-excels-analytical-tools\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"Data Cleansing Training - Consolidate Multiple Excel Workbooks &amp; Worksheets Using Power Query\"  class=\"wp-image-4589 size-medium aligncenter\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/PLC-VIDEO-2-THUMBNAIL-v2-300x169.png\" alt=\"Data Cleansing Training - Consolidate Multiple Excel Workbooks &amp; Worksheets Using Power Query\" width=\"300\" height=\"169\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/PLC-VIDEO-2-THUMBNAIL-v2-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/PLC-VIDEO-2-THUMBNAIL-v2-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/PLC-VIDEO-2-THUMBNAIL-v2-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/PLC-VIDEO-2-THUMBNAIL-v2.png 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p style=\"text-align: center; width: 31%; float: left; margin: 5px;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/consolidate-multiple-excel-workbooks-using-power-query\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"Data Cleansing Training - Different Ways to Format Data Using Power Query\"  class=\"aligncenter wp-image-3596 size-medium\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/06\/PLC-VIDEO-3-THUMBNAIL-with-play-300x169.png\" alt=\"Data Cleansing Training - Different Ways to Format Data Using Power Query\" width=\"300\" height=\"169\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/06\/PLC-VIDEO-3-THUMBNAIL-with-play-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/06\/PLC-VIDEO-3-THUMBNAIL-with-play-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/06\/PLC-VIDEO-3-THUMBNAIL-with-play-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/06\/PLC-VIDEO-3-THUMBNAIL-with-play.png 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<\/div>\n<pre><\/pre>\n<h3 style=\"text-align: center;\"><\/h3>\n<pre><\/pre>\n<hr \/>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"_NEW_ANNOUNCEMENT\"><\/span><span style=\"color: #0000ff;\">*** NEW ANNOUNCEMENT ***<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Listen_to_Oz_and_I_discuss_data_cleansing_our_upcoming_online_course%E2%80%A6\"><\/span><span style=\"color: #ff0000;\">Listen to Oz and I discuss data cleansing &amp;\u00a0our upcoming online course&#8230;<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<p><center><iframe src=\"\/\/html5-player.libsyn.com\/embed\/episode\/id\/4451214\/height\/90\/width\/640\/theme\/custom\/autoplay\/no\/autonext\/no\/thumbnail\/yes\/preload\/no\/no_addthis\/no\/direction\/backward\/no-cache\/true\/render-playlist\/no\/custom-color\/87A93A\/\" width=\"640\" height=\"90\" scrolling=\"no\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/center>&nbsp;<\/p>\n<hr \/>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"i\"><\/span><span style=\"color: #000000;\">\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Please_leave_a_comment_below_if_you_liked_this_video_or_if_you_have_any_questions_and_we_will_reply_back_with_a_fix_%F0%9F%99%82\"><\/span><span style=\"color: #000000;\">Please leave a comment below if you liked this video or if you have any questions\u00a0<\/span><span style=\"color: #000000;\">and we will reply back with a fix \ud83d\ude42\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"make_sure_to_be_specific_and_attach_example_workbook_links_if_possible\"><\/span><span style=\"color: #000000;\">(<em>make sure to be specific and attach example workbook links if possible<\/em>)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0The Ultimate Excel Power Query &amp; Data Cleansing Course is Closing its Doors\u00a0in&#8230; &nbsp; \u00a0BONUS VIDEO #2: Transform\u00a0an ERP Report to an Excel Pivot Table Dashboard &nbsp; In this training you are going to learn the following:Intro: Converting Financial Data into a Flat File 01:00 Starting the Solution 04:50 Add Conditional Column in PQ 07:10 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3726,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[1],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3723"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=3723"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3723\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/3726"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3723"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3723"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}