JSON data from cell to Columns

Copper Contributor

Hello Everyone,

I have a column in my excel File which has a simple non-nested data. I need to trasferthis data in columns , where variable name is column name and variable value is cell value.

Input Sample:

All Specification
{"Movement":"QUARTZ","Water Resistance Depth":"No waterproof","watch men":"erkek kol saati","Boxes & Cases Material":"No package","Item Type":"Quartz Wristwatches","relogio masculino":"watch","Model Number":"Quartz Watch","Feature":"Complete Calendar","Case Thickness":"10mm","Brand Name":"susenstone","Band Length":"24cm","Case Shape":"Round","Dial Diameter":"37.5mm","reloj hombre":"relojes para hombre","Band Width":"20mm","Band Material Type":"Leather","montre homme":"erkek saat","Style":"Fashion & Casual","Dial Window Material Type":"Glass","Clasp Type":"Buckle","Case Material":"Alloy"}
{"Movement":"QUARTZ","Occasion":"Daily Fashion Casual watch women","Water Resistance Depth":"No waterproof","Drop Shipping":"Accept Drop Shipping","Boxes & Cases Material":"No package","Item Type":"Wristwatches","Gender":"lovers'","Model Number":"sanjiaoxing wristwatch","Feature":"None","mens designer watches luxury watch":"mens watches top brand luxury","Case Thickness":"8.8mm","Brand Name":"RUNERR","Band Length":"22cm","Case Shape":"Round","montre homme marque de luxe":"relojes mujer marca de lujo 2018","Dial Diameter":"40mm","Top Selling Watch":"Casual Women Dress Watch","Band Material Type":"Stainless Steel","Band Width":"18mm","Style":"Fashion & Casual","Dial Window Material Type":"Hardlex","Clasp Type":"Leather Deployment Bucket","Case Material":"Stainless Steel","Application":"Gift Dailylife party"}
{"Movement":"QUARTZ","Water Resistance Depth":"3Bar","Item Type":"Quartz Wristwatches","Model Number":"MEGIR 2063","Feature":"Water Resistant","Case Thickness":"13.5mm","Brand Name":"NoEnName_Null","Band Length":"23cm","Case Shape":"Round","Dial Diameter":"46.5mm","Band Width":"24mm","Band Material Type":"Silicone","Style":"Fashion & Casual","Dial Window Material Type":"Glass","Clasp Type":"Buckle","Case Material":"Alloy"}
{"Movement":"Quartz","Water Resistance Depth":"3Bar","Boxes & Cases Material":"No package","Item Type":"Quartz Wristwatches","Gender":"Men","Model Number":"MVwuli WATCH","Feature":"None","Case Thickness":"8mm","Brand Name":"RUNERR","Band Length":"24cm","Case Shape":"Round","Dial Diameter":"42mm","Band Width":"20mm","Band Material Type":"Leather","Style":"Sport","Dial Window Material Type":"Glass","Clasp Type":"Buckle","Case Material":"Stainless Steel"}
{"DOOBO Watch Men":"Mens Quartz-Watch","Relogio Masculino":"Quartz Watch Brand Men","Movement":"QUARTZ","Quartz-Watch Men":"Sport Watches","Water Resistance Depth":"3Bar","Boxes & Cases Material":"Paper","Model Number":"D029 D002 D004 D020 D023 D025","Quartz Wristwatches":"Mens Watches Top Brand Luxury","Feature":"Auto Date","Fashion Casual Watch":"Watches For Men","Case Thickness":"12mm","Brand Name":"DOOBO","Band Length":"25cm","Case Shape":"Round","Dial Diameter":"45mm","Band Width":"23mm","Band Material Type":"Leather","Style":"Fashion & Casual","Dial Window Material Type":"Hardlex","Clasp Type":"Buckle","Mens Watch":"Mens Wristwatches","Case Material":"Alloy"}
{"Movement":"QUARTZ","Water Resistance Depth":"No waterproof","Boxes & Cases Material":"No package","Item Type":"Quartz Wristwatches","Model Number":"Man Watch relogio masculino reloj hombre erkek kol saati rolex watch","Feature":"None","Case Thickness":"8mm","Brand Name":"Rigardu","Band Length":"24cm","Case Shape":"Round","Dial Diameter":"30mm","Band Width":"20mm","Band Material Type":"Alloy","Style":"Fashion & Casual","Dial Window Material Type":"Glass","Clasp Type":"Buckle","Case Material":"Alloy"}
{"Fuction7":"watch for man","Fuction6":"clock men","Fuction5":"man watch","Fuction4":"men watches","Fuction3":"mens watch","Fuction2":"men watch","Fuction1":"watch men","Water Resistance Depth":"No waterproof","Feature":"Complete Calendar","Case Thickness":"8mm","Band Length":"24cm","Style":"simple","Dial Window Material Type":"Glass","Clasp Type":"Buckle","Case Material":"Alloy","Fuction9":"male clock","Fuction8":"watch man","Movement":"QUARTZ","Boxes & Cases Material":"No package","Item Type":"Quartz Wristwatches","Model Number":"/","Fuction":"reloj hombre","Brand Name":"CUENA","Case Shape":"Round","Dial Diameter":"40mm","Band Width":"20mm","Band Material Type":"Leather"}
{"Gender1":"Men Watches stainless steel","Water Resistance Depth":"No waterproof","Gender":"Men","Feature":"Fashion Alloy Band Watch Gold","Case Thickness":"8mm","Turkish":"bayan kol saati","Band Length":"23.5cm","Design":"golden creative watches","Portuguese":"relogio feminino","Style":"Fashion & Casual","Dial Window Material Type":"Glass","Clasp Type":"Buckle","Case Material":"Alloy","Item type":"Fashion Men Watches Steel Band","Movement":"QUARTZ","Watch Name":"ceasuri men","Boxes & Cases Material":"Paper","Item Type":"Quartz Wristwatches","Model Number":"jingxiu","Brand Name":"HIKUN","Case Shape":"Round","Dial Diameter":"40mm","French Name":"montre femme","Band Width":"20mm","Band Material Type":"Alloy","Spanish Name":"reloj mujer"}
{"Movement":"QUARTZ","Water Resistance Depth":"No waterproof","Boxes & Cases Material":"No package","Item Type":"Quartz Wristwatches","Model Number":"S9J1200001","Feature":"Back Light","Case Thickness":"10mm","Brand Name":"LSLONG","Band Length":"22.5cm","Case Shape":"Round","Dial Diameter":"45mm","Band Width":"20mm","Band Material Type":"Silicone","Style":"Fashion & Casual","Dial Window Material Type":"Acrylic","Clasp Type":"Buckle","Case Material":"Plastic"}
{"Movement":"QUARTZ","Water Resistance Depth":"3Bar","Boxes & Cases Material":"Paper","Item Type":"Quartz Wristwatches","Gender":"Men","Model Number":"NF9038M","Feature":"Water Resistant","Case Thickness":"12mm","Brand Name":"NAVIFORCE","Band Length":"24.2cm","Case Shape":"Round","Dial Diameter":"44mm","Band Width":"22mm","Band Material Type":"Stainless Steel","Style":"Fashion & Casual","Dial Window Material Type":"Glass","Clasp Type":"Bracelet Clasp","Case Material":"Stainless Steel"}
{"Watch Men's":"Watches Gift For Men","Movement":"QUARTZ","Quartz-Watch Men":"Sport Watch Men Watches","Water Resistance Depth":"3Bar","Men Watch":"Mens Watches Top Brand Luxury","Item Type":"Quartz Wristwatches","Model Number":"CRRJU2150","Feature":"Water Resistant","Case Thickness":"7mm","Brand Name":"CRRJU","Band Length":"24cm","Quartz-watch":"Business Watch","Case Shape":"Round","Dial Diameter":"40mm","Men's Watches":"Montre Homme Reloj Hombre","Relogios Masculino":"Quartz Watch Men","Band Width":"20mm","Band Material Type":"Stainless Steel","Style":"Fashion & Casual","Dial Window Material Type":"Hardlex","Clasp Type":"Hook Buckle","Case Material":"Alloy","Watches Style":"reloj hombre horloges mannen montre homm"}
{"Sports Watchs":"Famous Clock Male","Fashion Casual Watch ":"Relogio Feminino Montre Homme","Water Resistance Depth":"No waterproof","Gender":"Women","Feature":"LED display","Case Thickness":"10mm","Band Length":"23cm","Dial Window Material Type":"Glass","Style":"Fashion & Casual","Clasp Type":"Buckle","Relogio Masculino ":"Roman Business Hours","Case Material":"Stainless Steel"," watch women":" watchs men popular","Movement":"QUARTZ","Dress Lady Watch":"Dropship","Boxes & Cases Material":"Leather","Item Type":"Quartz Wristwatches","Model Number":"20180528","watch electronic":"Dropshipping","Brand Name":"Aimecor","Case Shape":"Round","Dial Diameter":"40mm","Band Width":"20mm","Band Material Type":"Leather","womens wristwatch ":"Mens Wristwatches","digital watch":"Drop Shipping"}
{"Movement":"QUARTZ","color":"colors","Water Resistance Depth":"3Bar","Boxes & Cases Material":"No package","Model Number":"101","Feature":"Water Resistant","Case Thickness":"14mm","Brand Name":"BOSALLY","Band Length":"24inch","Case Shape":"Round","Dial Diameter":"54mm","Band Width":"22mm","Band Material Type":"Leather","Style":"Fashion & Casual","Dial Window Material Type":"Hardlex","Clasp Type":"Buckle","Case Material":"Stainless Steel"}
{"sports watches":"man watch 2019","Water Resistance Depth":"3Bar","men's watches":"reloj","relogio masculino":"reloj hombre","Feature":"Water Resistant","Case Thickness":"8mm","Band Length":"24cm","ultra thin watch":"gift for men","Style":"Fashion & Casual","Dial Window Material Type":"Hardlex","Clasp Type":"None","Case Material":"Alloy","watches":"relogio","Movement":"QUARTZ","relojes":"horloges mannen","erkek saat":"montre","Boxes & Cases Material":"No package","Item Type":"Quartz Wristwatches","Model Number":"JS2436","relogios masculino":"montre homme 2019","Brand Name":"PLUOYO","Case Shape":"Round","Dial Diameter":"40mm","mens watches top brand luxury":"watch","Band Width":"20mm","Band Material Type":"Stainless Steel","orologio uomo":"montre homme","erkek kol saati":"military watch"}
{"Movement":"QUARTZ","Water Resistance Depth":"No waterproof","Boxes & Cases Material":"No package","Item Type":"Quartz Wristwatches","Feature":"Complete Calendar","Brand Name":"diesels","Band Length":"22inch","Case Shape":"Tonneau","Dial Diameter":"4mm","Band Material Type":"Stainless Steel","Style":"Fashion & Casual","Dial Window Material Type":"Glass","Clasp Type":"Bracelet Clasp","Case Material":"Stainless Steel"}
{"montre femme":"orologio donna","simple watch for men":"erkek kol saati","Water Resistance Depth":"No waterproof","women watch":"watches for women","Feature":"None","Case Thickness":"10mm","Band Length":"24cm","montre homme":"horloges mannen","Style":"Fashion & Casual","Dial Window Material Type":"Hardlex","quartz watch":"couple watches","Clasp Type":"Buckle","creative watches men":"Relogio Masculino","Case Material":"Alloy","Movement":"QUARTZ","casual watch men":"2018 reloj hombre","Boxes & Cases Material":"No package","Item Type":"Quartz Wristwatches","Model Number":"couple wristwatches","Brand Name":"Gorben","Case Shape":"Round","Dial Diameter":"40mm","Band Width":"20mm","Band Material Type":"Leather","men watch":"wristwatches for men","orologio uomo":"reloj hombre 2018"}
{"Spain Words":"reloj de las mujeres,Cuarzo relojes","One":"Valentine's Day Gifts","Water Resistance Depth":"3Bar","Gender":"Men","Feature":"Auto Date","France Words":"montre Femme,nouvelles femmes horloge","Case Thickness":"8mm","Band Length":"24.5cm","For the Crowd":"Men,lady, girls,nosotros,femelle,Mujer","Style":"Sport","Dial Window Material Type":"Glass","Clasp Type":"Wristwatches","Case Material":"Stainless Steel","Brazil Words":"Quartzo mulheres assistem,relogios dos mulh","Condition":"New without tags","Movement":"QUARTZ","Color":"Natural Color","Boxes & Cases Material":"Paper","Item Type":"Quartz Wristwatches","Model Number":"Quartz Wristwatches","Brand Name":"xiniu","Case Shape":"Round","Dial Diameter":"45mm","Band Material Type":"Canvas","Band Width":"22mm"}
{"Movement":"QUARTZ","Water Resistance Depth":"3Bar","Boxes & Cases Material":"Paper","Item Type":"Quartz Wristwatches","Model Number":"LIGE9929","Feature":"Swim","Case Thickness":"12mm","Brand Name":"LIGE","Band Length":"25.5cm","Case Shape":"Round","Dial Diameter":"44mm","Band Width":"22mm","Band Material Type":"Stainless Steel","Style":"Fashion & Casual","Dial Window Material Type":"Hardlex","Clasp Type":"Hook Buckle","Case Material":"Stainless Steel"}
{"Movement":"QUARTZ","Water Resistance Depth":"3Bar","Boxes & Cases Material":"Paper","Item Type":"Quartz Wristwatches","Model Number":"AE-006","Feature":"Complete Calendar","Case Thickness":"11mm","Brand Name":"TWINCITY","Band Length":"24cm","Case Shape":"Round","Dial Diameter":"40mm","feature":"Auto Date, full steel","Band Width":"22mm","Band Material Type":"Stainless Steel","men watch":"business,fashion","Style":"Business","Dial Window Material Type":"Hardlex","Clasp Type":"Push Button Hidden Clasp","Case Material":"Stainless Steel"}
{"Brazil word":"esportivo relogios dos homens marca luxo","case material":"stainless steel","crowd":"men male student boys  lover couple","Water Resistance Depth":"No waterproof","relogio masculino":"reloj mujer runer brand men watch","Feature":"None","Case Thickness":"10mm","Band Length":"22cm","Spain word":"deportivos relojs hombre de marca lujo famosas","feature":"blue ray watch","diameter":"10mm","Style":"Fashion & Casual","Dial Window Material Type":"Hardlex","Clasp Type":"Buckle","model":"nanshi watch men","Case Material":"Stainless Steel","relogio feminino":"satovi klokker klockor ure horloges mannen","item":"quartz wristwatches","Movement":"QUARTZ","length":"22cm","Boxes & Cases Material":"No package","Item Type":"Quartz Wristwatches","Model Number":"nanshi elegant male clock 2019","men clock":"relogio masculino fashion simple watch","Brand Name":"RUNERR","Case Shape":"Round","Dial Diameter":"34mm","Band Material Type":"Leather","Band Width":"16mm","men watch":"reloj mujer fashion casual dress trendy popular watch 2019","width":"16mm","style":"dress/fashion/casual/trendy/popular elegantcreative","erkek kol saati":"montre femme for men 2019","reloj mujer":"zegarek damski dress watch foe male 2018","band material":"leather strap watch"}
{"Army":"Sport Watches For Men","Movement":"Quartz","2018 New Casual Watch Quartz Watches":" Reloj De Lujo festival Memorial Day gift saat","Water Resistance Depth":"No waterproof","Boxes & Cases Material":"No package","Item Type":"Quartz Wristwatches","Model Number":"Watch","Feature":"None","Case Thickness":"9mm","Band Length":"27.5cm","Brand Name":"Bowake","Case Shape":"Round","New Arrival Girls Ladies Women's Watch":"Women Men Business Watch Relogio Feminino Saat","Dial Diameter":"38.5mm","Analog":"alloy","Band Width":"18mm","Band Material Type":"Stainless Steel","Brazil words":"esportivo relogios dos homens marca luxo mascuslino relogio de pulso","Dial Window Material Type":"Glass","Style":"\tCasual","Clasp Type":"Bracelet Clasp","Case Material":"Stainless Steel","Montre Homme: Montre Homme De Marque":"Elegant Analog Quartz Watch Female Clock Saat erkek kol saati","Display":"Analog"}
{"Movement":"QUARTZ","Water Resistance Depth":"No waterproof","Boxes & Cases Material":"No package","Feature":"None","Case Thickness":"8mm","Brand Name":"YOLAKO","Band Length":"23cm","Case Shape":"Round","Dial Diameter":"40mm","Band Width":"20mm","Band Material Type":"Stainless Steel","Style":"Fashion & Casual","Dial Window Material Type":"Glass","Clasp Type":"None","Case Material":"Stainless Steel"}
{"Movement":"QUARTZ","Water Resistance Depth":"No waterproof","Boxes & Cases Material":"No package","Item Type":"Quartz Wristwatches","Feature":"Auto Date","Brand Name":"BOSS","Band Length":"22inch","Case Shape":"Tonneau","Dial Diameter":"4.3mm","Band Material Type":"Stainless Steel","Style":"Fashion & Casual","Dial Window Material Type":"Glass","Clasp Type":"Bracelet Clasp","Case Material":"Stainless Steel"}
{"Movement":"QUARTZ","Water Resistance Depth":"No waterproof","Boxes & Cases Material":"No package","Model Number":"2019","Feature":"Compass","Case Thickness":"10mm","Brand Name":"Aimecor","Band Length":"26.5cm","Case Shape":"Round","Dial Diameter":"40mm","Band Width":"20mm","Band Material Type":"Silicone","Style":"simple","Dial Window Material Type":"Glass","Clasp Type":"Buckle","Case Material":"Alloy"}

 

Some cells has variable names that are not present in other cells, in this case i want a new column to be created according to variable name and add "NULL" for cells where data is not present.
Also say "Band Width" column is created then data of Band Width of all cells should come under stant column.


Please help, how can i do this.

Thanks in advance.

6 Replies

@shubham855 

You may do that with Power Query - query you table with JSON texts, parse column as JSON and expand result.

 

Generated script looks like

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Parsed JSON" = Table.TransformColumns(
        Source,
        {},Json.Document
    ),
    #"Expanded All Specification" = Table.ExpandRecordColumn(
        #"Parsed JSON",
        "All Specification",
        {"Movement", "Water Resistance Depth", "watch men", "Boxes & Cases Material",
         "Item Type", "relogio masculino", "Model Number", "Feature", "Case Thickness",
         "Brand Name", "Band Length", "Case Shape", "Dial Diameter", "reloj hombre",
         "Band Width", "Band Material Type", "montre homme", "Style",
         "Dial Window Material Type", "Clasp Type", "Case Material", "Occasion",
         "Drop Shipping", "Gender", "mens designer watches luxury watch",
         "montre homme marque de luxe", "Top Selling Watch", "Application"},
         {"Movement", "Water Resistance Depth", "watch men", "Boxes & Cases Material",
          "Item Type", "relogio masculino", "Model Number", "Feature", "Case Thickness",
          "Brand Name", "Band Length", "Case Shape", "Dial Diameter", "reloj hombre",
          "Band Width", "Band Material Type", "montre homme", "Style",
          "Dial Window Material Type", "Clasp Type", "Case Material", "Occasion",
          "Drop Shipping", "Gender", "mens designer watches luxury watch",
          "montre homme marque de luxe", "Top Selling Watch", "Application"}
    )
in
    #"Expanded All Specification"

Please check in attached.

 

First of all , thanks for replying.

The query that you gave has names of "variables" in jsons. I have a huge data, how can i dentify unique variables in that data.
Can't i get some code which automatically makes "variable" names as column names and values in cells. without any hardcoding

@shubham855 

But here nothing is hardcoded, query takes columns names automatically from JSON file.

I am not sure is anyone can help me, or not, but I am trying to use excel for the first time, and for my school assignment, I have to put all my assignments from each class in the calendar, and I have watched excel videos, but I am not understanding what I need to do, to make the cell bigger so that I can input more information in one cell at a time. Can anybody please help me?

@Sergei Baklan 

Expanded All selection step in query has column names

"All Specification",
        {"Movement", "Water Resistance Depth", "watch men", "Boxes & Cases Material",
         "Item Type", "relogio masculino", "Model Number", "Feature", "Case Thickness",
         "Brand Name", "Band Length", "Case Shape", "Dial Diameter", "reloj hombre",
         "Band Width", "Band Material Type", "montre homme", "Style",
         "Dial Window Material Type", "Clasp Type", "Case Material", "Occasion",
         "Drop Shipping", "Gender", "mens designer watches luxury watch",
         "montre homme marque de luxe", "Top Selling Watch", "Application"},
         {"Movement", "Water Resistance Depth", "watch men", "Boxes & Cases Material",
          "Item Type", "relogio masculino", "Model Number", "Feature", "Case Thickness",
          "Brand Name", "Band Length", "Case Shape", "Dial Diameter", "reloj hombre",
          "Band Width", "Band Material Type", "montre homme", "Style",
          "Dial Window Material Type", "Clasp Type", "Case Material", "Occasion",
          "Drop Shipping", "Gender", "mens designer watches luxury watch",
          "montre homme marque de luxe", "Top Selling Watch", "Application"}

@shubham855 

Actually much more if don't skip Load more on expanding. All variables in your sample are

        "All Specification",
        {"Movement", "Water Resistance Depth", "watch men", "Boxes & Cases Material",
        "Item Type","relogio masculino", "Model Number", "Feature", "Case Thickness",
        "Brand Name", "Band Length","Case Shape", "Dial Diameter", "reloj hombre",
        "Band Width", "Band Material Type", "montre homme","Style",
        "Dial Window Material Type", "Clasp Type", "Case Material", "Occasion",
        "Drop Shipping", "Gender", "mens designer watches luxury watch",
        "montre homme marque de luxe", "Top Selling Watch", "Application",
        "DOOBO Watch Men", "Relogio Masculino", "Quartz-Watch Men", "Quartz Wristwatches",
        "Fashion Casual Watch", "Mens Watch", "Fuction7", "Fuction6", "Fuction5",
        "Fuction4", "Fuction3","Fuction2", "Fuction1", "Fuction9", "Fuction8", "Fuction",
        "Gender1", "Turkish", "Design","Portuguese", "Item type", "Watch Name",
        "French Name", "Spanish Name", "Watch Men's", "Men Watch", "Quartz-watch",
        "Men's Watches", "Relogios Masculino", "Watches Style", "Sports Watchs",
        "Fashion Casual Watch ", "Relogio Masculino ", " watch women", "Dress Lady Watch",
        "watch electronic", "womens wristwatch ", "digital watch", "color", "sports watches",
        "men's watches", "ultra thin watch", "watches", "relojes", "erkek saat",
        "relogios masculino","mens watches top brand luxury", "orologio uomo",
        "erkek kol saati", "montre femme","simple watch for men", "women watch",
        "quartz watch", "creative watches men","casual watch men", "men watch", "Spain Words",
        "One", "France Words", "For the Crowd","Brazil Words", "Condition", "Color",
        "feature", "Brazil word", "case material", "crowd","Spain word", "diameter",
        "model", "relogio feminino", "item", "length", "men clock","width", "style",
        "reloj mujer", "band material", "Army", "2018 New Casual Watch Quartz Watches",
        "New Arrival Girls Ladies Women's Watch", "Analog", "Brazil words",
        "Montre Homme: Montre Homme De Marque", "Display"},

        {"Movement", "Water Resistance Depth", "watch men", "Boxes & Cases Material",
        "Item Type","relogio masculino", "Model Number", "Feature", "Case Thickness",
        "Brand Name", "Band Length","Case Shape", "Dial Diameter", "reloj hombre",
        "Band Width", "Band Material Type", "montre homme","Style",
        "Dial Window Material Type", "Clasp Type", "Case Material", "Occasion",
        "Drop Shipping", "Gender", "mens designer watches luxury watch",
        "montre homme marque de luxe", "Top Selling Watch", "Application",
        "DOOBO Watch Men", "Relogio Masculino", "Quartz-Watch Men", "Quartz Wristwatches",
        "Fashion Casual Watch", "Mens Watch", "Fuction7", "Fuction6", "Fuction5",
        "Fuction4", "Fuction3","Fuction2", "Fuction1", "Fuction9", "Fuction8", "Fuction",
        "Gender1", "Turkish", "Design","Portuguese", "Item type", "Watch Name",
        "French Name", "Spanish Name", "Watch Men's", "Men Watch", "Quartz-watch",
        "Men's Watches", "Relogios Masculino", "Watches Style", "Sports Watchs",
        "Fashion Casual Watch ", "Relogio Masculino ", " watch women", "Dress Lady Watch",
        "watch electronic", "womens wristwatch ", "digital watch", "color", "sports watches",
        "men's watches", "ultra thin watch", "watches", "relojes", "erkek saat",
        "relogios masculino","mens watches top brand luxury", "orologio uomo",
        "erkek kol saati", "montre femme","simple watch for men", "women watch",
        "quartz watch", "creative watches men","casual watch men", "men watch", "Spain Words",
        "One", "France Words", "For the Crowd","Brazil Words", "Condition", "Color",
        "feature", "Brazil word", "case material", "crowd","Spain word", "diameter",
        "model", "relogio feminino", "item", "length", "men clock","width", "style",
        "reloj mujer", "band material", "Army", "2018 New Casual Watch Quartz Watches",
        "New Arrival Girls Ladies Women's Watch", "Analog", "Brazil words",
        "Montre Homme: Montre Homme De Marque", "Display"}

but that's how you JSON file is built. Power Query takes all variables automatically. In UI there are only three steps which are not required any coding.

image.png

Sorry, but I didn't catch what do you expect from the transformation.