Need to convert an array of numbers to two columns in excel

s_t

Joined
Feb 8, 2014
Messages
1
Reaction score
0
I have the following array:
[{"x":1.3848356749650856,"y":24342.0},{"x":13.397886407147407,"y":3134.0},{"x":23.694624509033744,"y":1273.0},{"x":33.913901578458656,"y":1077.0},{"x":48.87005510907003,"y":871.0},{"x":65.50778663793099,"y":464.0},{"x":83.33474884792624,"y":434.0},{"x":101.90762135922336,"y":206.0},{"x":119.707884057971,"y":207.0},{"x":136.38685039370097,"y":127.0},{"x":150.23927868852456,"y":61.0},{"x":161.41298113207546,"y":53.0},{"x":175.32946153846152,"y":78.0},{"x":191.29875324675325,"y":77.0},{"x":208.8214905660377,"y":53.0},{"x":219.1891818181818,"y":22.0},{"x":231.62616666666662,"y":42.0},{"x":244.4318636363636,"y":22.0},{"x":256.46977419354835,"y":31.0},{"x":268.0537083333333,"y":24.0},{"x":284.69655,"y":20.0},{"x":296.7318125,"y":16.0},{"x":308.0758857142857,"y":35.0},{"x":325.36880952380943,"y":21.0},{"x":338.71708333333333,"y":12.0},{"x":349.3176428571429,"y":14.0},{"x":359.54769999999996,"y":10.0},{"x":372.5523999999999,"y":10.0},{"x":382.8708,"y":10.0},{"x":393.24192307692306,"y":13.0},{"x":404.7407,"y":10.0},{"x":420.55330769230767,"y":13.0},{"x":438.20645454545456,"y":11.0},{"x":455.2833076923078,"y":13.0},{"x":474.5165454545454,"y":11.0},{"x":487.67414285714284,"y":7.0},{"x":506.50827272727275,"y":11.0},{"x":519.015,"y":5.0},{"x":536.0832000000001,"y":10.0},{"x":550.8909166666666,"y":12.0},{"x":579.5312,"y":5.0},{"x":593.635,"y":3.0},{"x":607.952,"y":1.0},{"x":629.30775,"y":4.0},{"x":641.6460000000001,"y":1.0},{"x":661.25325,"y":4.0},{"x":671.6320000000001,"y":4.0},{"x":683.68,"y":5.0},{"x":698.8593999999998,"y":5.0},{"x":713.5432,"y":5.0},{"x":727.9314,"y":5.0},{"x":743.9295999999999,"y":5.0},{"x":758.059,"y":2.0},{"x":768.3773333333334,"y":3.0},{"x":783.316,"y":2.0},{"x":796.59375,"y":4.0},{"x":822.577,"y":2.0},{"x":843.53675,"y":4.0},{"x":854.635,"y":1.0},{"x":865.965,"y":1.0},{"x":880.1450000000001,"y":4.0},{"x":901.0110000000001,"y":1.0},{"x":926.7349999999999,"y":4.0},{"x":996.8165,"y":2.0},{"x":1011.2420000000001,"y":1.0},{"x":1025.6146666666668,"y":3.0},{"x":1053.35,"y":1.0},{"x":1067.6150000000002,"y":2.0},{"x":1079.557,"y":1.0},{"x":1111.607,"y":1.0},{"x":1130.1867499999998,"y":4.0},{"x":1176.609,"y":1.0},{"x":1193.6412500000001,"y":4.0},{"x":1215.30975,"y":4.0},{"x":1239.033,"y":2.0},{"x":1256.511,"y":1.0},{"x":1268.327,"y":1.0},{"x":1282.5819999999999,"y":1.0},{"x":1333.7615,"y":2.0},{"x":1360.4850000000001,"y":1.0},{"x":1391.993,"y":1.0},{"x":1405.8390000000002,"y":1.0},{"x":1428.789,"y":1.0},{"x":1442.9329999999998,"y":1.0},{"x":1466.71,"y":1.0},{"x":1489.379,"y":1.0},{"x":1506.8799999999997,"y":2.0},{"x":1558.295,"y":1.0},{"x":1575.416,"y":1.0},{"x":1595.519,"y":1.0},{"x":1645.3274999999999,"y":2.0},{"x":1690.9005000000002,"y":2.0},{"x":1717.044,"y":1.0},{"x":1738.664,"y":1.0},{"x":1761.2849999999999,"y":1.0},{"x":1788.248,"y":2.0},{"x":1801.4009999999998,"y":2.0},{"x":1851.886,"y":1.0},{"x":1901.4559999999997,"y":1.0},{"x":1918.3995,"y":2.0},{"x":1965.7859999999998,"y":1.0},{"x":2028.1775,"y":2.0},{"x":2039.219,"y":1.0},{"x":2104.163,"y":1.0},{"x":2207.568,"y":1.0},{"x":2546.309,"y":1.0},{"x":2586.45,"y":1.0},{"x":2838.5159999999996,"y":1.0},{"x":2930.1770000000006,"y":1.0},{"x":2964.2080000000005,"y":1.0},{"x":3273.564,"y":1.0},{"x":3415.618,"y":1.0},{"x":3516.1150000000002,"y":1.0},{"x":3750.419,"y":1.0},{"x":4112.753,"y":1.0},{"x":4679.177,"y":1.0},{"x":6807.358,"y":1.0},{"x":16769.726,"y":1.0},{"x":30241.836,"y":1.0},{"x":47646.172999999995,"y":1.0}]


And want two have x and y in two columns -How would I do this?

Thank you :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top