JSON data from cell to Columns
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.