Skip to main content
Tweeted twitter.com/StackMma/status/1452379376629260296
Copy edited (e.g. ref. <en.wikipedia.org/wiki/Microsoft_Excel> and <en.wiktionary.org/wiki/dimension#Noun>) - but work is needed near "I want to second number of each this two-member list goes to the" and "show my mean" (seems incomprehensible). Removed meta information (this belongs in comments).
Source Link

what What is the best way to flatten thea nested list?

I have a list called matcoeffE which has dimensions {10, 9, 7, 2}. However, however I want to build a matrix with dimensions {180,7} and then export it as an excelExcel file. At the first step I used:

newmat = FlattenAt[matcoeffE, Transpose[{Range[10]}]]; 

so dimensions of newmat became {90, 7, 2}. After that I have to flatten 2 (2*90) and get a new matrix which dimenstionshas dimensions {180,7}which which produces an excelExcel file with 190 rows and 7 columns (in a single sheet). My mean is: newmat has 90 rows and 7 columns which each column has two numbers in it  . I want to second number of each this two-member list goes to the next row (namely each second member is placed under the first member), so that the dimensions will be {180,7}. I tried to show my mean schematically as follows:   

enter image description hereEnter image description here

I tried Splice for example, but it didn't work. In fact I always have a problem with flattening the nested list. How can I would be so grateful if someone helps me to solve my problem and also suggest? Is there a simple and general way to flatten nested lists. Thanks in advance.?

what is the best way to flatten the nested list?

I have a list called matcoeffE which has dimensions {10, 9, 7, 2}, however I want to build a matrix with dimensions {180,7} and then export it as an excel file. At the first step I used

newmat = FlattenAt[matcoeffE, Transpose[{Range[10]}]]; 

so dimensions of newmat became {90, 7, 2}. After that I have to flatten 2 (2*90) and get a new matrix which dimenstions {180,7}which produces an excel file with 190 rows and 7 columns (in a single sheet). My mean is: newmat has 90 rows and 7 columns which each column has two numbers in it  . I want to second number of each this two-member list goes to the next row (namely each second member is placed under the first member) so that the dimensions will be {180,7} I tried show my mean schematically as follows:  enter image description here

I tried Splice for example but it didn't work. In fact I always have problem with flattening the nested list. I would be so grateful if someone helps me to solve my problem and also suggest a simple and general way to flatten nested lists. Thanks in advance.

What is the best way to flatten a nested list?

I have a list called matcoeffE which has dimensions {10, 9, 7, 2}. However, I want to build a matrix with dimensions {180,7} and then export it as an Excel file. At the first step I used:

newmat = FlattenAt[matcoeffE, Transpose[{Range[10]}]]; 

so dimensions of newmat became {90, 7, 2}. After that I have to flatten 2 (2*90) and get a new matrix which has dimensions {180,7} which produces an Excel file with 190 rows and 7 columns (in a single sheet). My mean is: newmat has 90 rows and 7 columns which each column has two numbers in it. I want to second number of each this two-member list goes to the next row (namely each second member is placed under the first member), so that the dimensions will be {180,7}. I tried to show my mean schematically as follows: 

Enter image description here

I tried Splice for example, but it didn't work. In fact I always have a problem with flattening the nested list. How can I solve my problem? Is there a simple and general way to flatten nested lists?

Became Hot Network Question
deleted 23034 characters in body
Source Link
Wisdom
  • 1.3k
  • 7
  • 17

I tried Splice for example but it didn't work. In fact I always have problem with flattening the nested list. I would be so grateful if someone helps me to solve my problem and also suggest a simple and general way to flatten nested lists. Thanks in advance. I put my original matrix so that everyone can play with it and find a solution:

matcoeffE={{{{0.337105218393, 0.056193}, {0.294455728512, 0.0324089}, {0.229748751017, 0.0240914}, {0.119148671044, 0.0142299}, {0.0664237134392, 0.1101117}, {0.00360028488651, 0.0070176}, {0.00321876229242, 0.0095059}}, {{0.374477003626, 0.0403286}, {0.29370920304, 0.0250041}, {0.209377864083, 0.0702602}, {0.131720218978, 0.0155015}, {0.0285694972792, 0.1281731}, {0.00863878243626, 0.0084664}, {0.000774968910065, 0.1645551}}, {{0.353907169894, 0.0501186}, {0.282474762619, 0.0214335}, {0.24538956531, 0.0329434}, {0.122729046207, 0.0934136}, {0.0374967404997, 0.0117783}, {0.00409111482812, 0.2076852}, {0.000475343415407, 0.2700238}}, {{0.53811512475, 0.0742594}, {0.170318148036, 0.05256}, {0.161678229565, 0.1208489}, {0.141656495447, 0.1554391}, {0.035514890258, 0.4215684}, {0.0289076045686, 0.5146527}, {0.00613051478656, 0.664291}}, {{0.713827443266, 0.5416797}, {0.115140609435, 0.4651387}, {0.102812097576, 0.7638984}, {0.0707016321359, 1.0043789}, {0.00599167476141, 1.9316328}, {0.000637054993659, 3.8171602}, {0.000189278672094, 5.4195293}}, {{0.835519060786, 5.1245625}, {0.107002120313, 4.7648438}, {0.0582202117269, 7.9818359}, {0.00235609532767, 19.733625}, {0.000883428336476, 36.1043437}, {0.000591486899281, 59.8889375}, {0.000274137306624, 73.121875}}, {{0.797822870474, 51.7597656}, {0.238092217028, 44.683125}, {0.0395767606479, 39.371875}, {0.00675078217198, 127.570625}, {0.00247722719796, 165.378125}, {0.000421934277043, 346.0825}, {0.00023532357072, 402.5625}}, {{0.814777900984, 508.4657715}, {0.188879629401, 469.8193359}, {0.00471773717827, 372.3222656}, {0.00144832509778, 1205.078125}, {0.000669589290873, 2717.5828125}, {0.000558343657888, 3008.703125}, {0.0000245903493125, 5038.5382812}}, {{0.772879788376, 5094.921875}, {0.243590194039, 4643.1782227}, {0.0193061267018, 3577.8125}, {0.00287759315129, 2833.828125}, {0.0000534470768605, 26213.71875}, {0.0000145819727195, 45381.328125}, {3.09771296336*10^-7, 312053.9375}}}, {{{0.303693119093, 0.056193}, {0.237265518175, 0.0382683}, {0.225650952584, 0.0251309}, {0.199797160722, 0.0944867}, {0.0463135246782, 0.0142299}, {0.0404471019324, 0.1725289}, {0.000100058428638, 0.7570176}}, {{0.3487394747, 0.0403286}, {0.321833428752, 0.0702602}, {0.201142045915, 0.0259806}, {0.107900509321, 0.1281731}, {0.067034074849, 0.0155015}, {0.00699454832318, 0.2584664}, {0.000420629669261, 0.4145551}}, {{0.389207013526, 0.0501186}, {0.246897089573, 0.0934136}, {0.206279490703, 0.0329434}, {0.161545603996, 0.0214335}, {0.0302243453964, 0.1762738}, {0.0111093028478, 0.0117783}, {0.00686831864122, 0.2076852}}, {{0.467275250226, 0.0742594}, {0.238329871874, 0.1208489}, {0.143000989862, 0.1554391}, {0.110382195975, 0.05256}, {0.0705097318499, 0.2646527}, {0.00253376493807, 0.4215684}, {0.000606394390292, 0.664291}}, {{0.661617883744, 0.5416797}, {0.167695730963, 0.7638984}, {0.0963091905633, 0.4651387}, {0.0730772755963, 1.1293789}, {0.0138145655973, 1.9316328}, {0.000466639107665, 2.8171602}, {0.0000509136064617, 5.4195293}}, {{0.833373633549, 5.1245625}, {0.0881514708645, 4.7648438}, {0.0757376260069, 7.9818359}, {0.0302202976214, 19.733625}, {0.024001912395, 21.1043437}, {0.000584143658157, 37.8889375}, {0.0000458966960018, 73.121875}}, {{0.808173208638, 51.7597656}, {0.213868587962, 44.683125}, {0.0297655773869, 38.871875}, {0.00962316567181, 114.070625}, {0.000770644945905, 165.378125}, {0.000381591000288, 346.0825}, {0.000218506763466, 402.5625}}, {{0.789951387113, 509.9657715}, {0.213562199711, 469.8193359}, {0.00543519745044, 372.3222656}, {0.00244143032211, 1205.078125}, {0.000628846880473, 2717.5828125}, {0.000545617803204, 3008.703125}, {0.0000261195944445, 5038.5382812}}, {{0.66288560564, 5145.921875}, {0.360079344396, 4679.6782227}, {0.0260887078954, 3643.3125}, {0.00314613005764, 2833.828125}, {0.000147724072458, 26213.71875}, {0.0000403274425436, 45381.328125}, {9.02172204944*10^-7, 312053.9375}}}, {{{0.456673392295, 0.056193}, {0.258334129604, 0.1139352}, {0.168974465005, 0.0265488}, {0.116200808341, 0.0324089}, {0.091569239737, 0.2663617}, {0.0597554437238, 0.2798549}, {0.0257414513917, 0.0143887}}, {{0.362058141104, 0.0702602}, {0.323306909966, 0.0403286}, {0.163083648542, 0.1281731}, {0.140755713588, 0.0250041}, {0.0308223560747, 0.0155015}, {0.0196061024677, 0.2584664}, {0.0180816953095, 0.1645551}}, {{0.343491769209, 0.0816948}, {0.302903894711, 0.0462123}, {0.184131308012, 0.0329434}, {0.104983036389, 0.1450238}, {0.0866389972346, 0.0194804}, {0.0321899670767, 0.2076852}, {0.00249590630902, 0.3867783}}, {{0.416161799777, 0.0742594}, {0.266438030108, 0.1208489}, {0.151243489211, 0.1554391}, {0.115793451563, 0.2646527}, {0.0800396617974, 0.05256}, {0.0113880779019, 0.5465684}, {0.00226355745604, 0.664291}}, {{0.636158131055, 0.5416797}, {0.185603576845, 0.7638984}, {0.0864661704891, 1.1293789}, {0.0816704302792, 0.4651387}, {0.0249952757516, 1.9316328}, {0.000470472578609, 3.9195293}, {0.000149374893022, 2.8171602}}, {{0.876501207045, 5.1245625}, {0.0812088920302, 8.0443359}, {0.0353647420904, 4.5148438}, {0.0150844928412, 16.733625}, {0.00318514994609, 21.1043437}, {0.000361526580091, 37.8889375}, {0.0000304850860559, 73.121875}}, {{0.808918112296, 51.7597656}, {0.191323721264, 45.183125}, {0.0116345008524, 110.070625}, {0.0109048358399, 36.371875}, {0.000528105573106, 165.378125}, {0.000497606911561, 346.0825}, {0.000276209166924, 402.5625}}, {{0.783915149687, 510.4657715}, {0.218901576865, 469.8193359}, {0.00544727538068, 372.3222656}, {0.00318807233467, 1204.078125}, {0.00040015456217, 3008.703125}, {0.000384757210729, 2717.5828125}, {0.0000243018304851, 5038.5382812}}, {{1.00875018249, 4958.1782227}, {0.0322092150795, 4195.8125}, {0.0224685283176, 6361.421875}, {0.00102487623067, 2842.328125}, {0.000179911273948, 26211.21875}, {0.0000405811030711, 45381.328125}, {8.13557423522*10^-7, 312053.9375}}}, {{{0.354225109934, 0.0886273}, {0.347694634477, 0.0480339}, {0.153259978948, 0.1548549}, {0.108547604664, 0.0288493}, {0.0594071950625, 0.2506539}, {0.0362035984726, 0.0192715}, {0.00489664460763, 0.4757676}}, {{0.665440342079, 0.0481411}, {0.432156202277, 0.0812981}, {0.373920820155, 0.0546352}, {0.198431750515, 0.1567426}, {0.100346601871, 0.0228068}, {0.0403149432067, 0.2975289}, {0.00142436173149, 0.5155015}}, {{0.415859312055, 0.0501186}, {0.379262000676, 0.1012261}, {0.133129803922, 0.2076852}, {0.125231739592, 0.0251309}, {0.00947725176645, 0.4433085}, {0.000864683621561, 0.0078721}, {0.000162087287215, 1.0200238}}, {{0.347997596392, 0.0742594}, {0.283654206546, 0.1208489}, {0.168749255129, 0.2646527}, {0.162487385284, 0.1554391}, {0.0504259956017, 0.05256}, {0.0293915458282, 0.4840684}, {0.00507051288577, 0.664291}}, {{0.58108030387, 0.5416797}, {0.159793269513, 0.7013984}, {0.15688374963, 1.0043789}, {0.0699065610027, 0.4651387}, {0.0503789896472, 1.9316328}, {0.00621350227585, 4.8171602}, {0.00337305714118, 5.4195293}}, {{0.879185520379, 5.1245625}, {0.0889620446086, 7.9818359}, {0.0169631948878, 14.233625}, {0.0165662900907, 4.2648437}, {0.00516769019762, 21.1043437}, {0.000525986662014, 37.8889375}, {0.0000224399831243, 73.121875}}, {{0.767443534729, 51.7597656}, {0.219497383273, 46.433125}, {0.0155287979558, 97.570625}, {0.0041321881041, 34.871875}, {0.00362692308715, 165.378125}, {0.00078489199258, 346.0825}, {0.000345891085312, 402.5625}}, {{0.768734743394, 511.4657715}, {0.233659618215, 469.8193359}, {0.00591859518444, 372.3222656}, {0.00401755489527, 1204.078125}, {0.000203786465613, 2717.5828125}, {0.0000857443745085, 3008.703125}, {0.0000149068779031, 5038.5382812}}, {{0.760091509734, 5137.421875}, {0.288560985837, 4475.6782227}, {0.0538484983699, 3685.8125}, {0.00507009636824, 2834.828125}, {0.000416893433163, 22866.21875}, {0.0000476392864995, 45381.328125}, {1.30052394563*10^-6, 312053.9375}}}, {{{0.386310196382, 0.0865914}, {0.332921941423, 0.1755414}, {0.17799338315, 0.0435268}, {0.149176901113, 0.370834}, {0.0268601560027, 0.8058457}, {0.0260656953947, 0.0226433}, {0.0153671284924, 0.024943}}, {{2.4389171684, 0.099557}, {2.26291328993, 0.1062466}, {0.577556664253, 0.158857}, {0.156752671205, 0.0381876}, {0.115925798297, 0.3645012}, {0.0417176216582, 0.4790082}, {0.0158043546084, 0.9237046}}, {{0.368284183893, 0.0660698}, {0.337652880227, 0.1321498}, {0.18636442394, 0.2270551}, {0.125561165854, 0.0348965}, {0.115291016596, 0.4141221}, {0.070199225543, 0.044871}, {0.0207326379841, 0.8678414}}, {{0.404385576213, 0.1442864}, {0.279658644019, 0.0781657}, {0.270632806944, 0.289291}, {0.106757016301, 0.6140834}, {0.0178552809682, 1.3278184}, {0.0152041146993, 0.0734078}, {0.0099348901018, 0.0459027}}, {{0.630183333641, 0.5685859}, {0.249413630792, 1.0043789}, {0.0824630587623, 2.1530977}, {0.0547586565779, 0.4407246}, {0.0179446476122, 4.7632793}, {0.00268580196679, 7.3378828}, {0.000401744299572, 13.3385547}}, {{0.763211159584, 5.1245625}, {0.122275801622, 8.1039062}, {0.0930888641154, 4.9601563}, {0.0295539126242, 18.2687812}, {0.00535171560314, 47.6277812}, {0.0000583299326326, 251.246875}, {0.0000134622249122, 567.7014375}}, {{0.884282647609, 51.7597656}, {0.200545237693, 40.2885938}, {0.103232341157, 37.9070313}, {0.0191926673242, 120.9788281}, {0.00335627673797, 316.2973437}, {0.000281407246197, 816.625}, {0.0000121400209066, 1702.4875}}, {{0.894552850514, 508.9235352}, {0.152363094041, 433.1982422}, {0.0521240828822, 401.6191406}, {0.00562321358454, 1252.7390625}, {0.00121335266996, 3526.28125}, {0.000330439413787, 4413.5382813}, {0.000110608388206, 7435.546875}}, {{0.833736706984, 5094.8980331}, {0.184572645005, 4498.8300781}, {0.0231764470276, 3480.15625}, {0.00406145097323, 2833.828125}, {0.00111080643037, 16863.1328125}, {0.000141094300912, 47646.953125}, {1.17585428566*10^-6, 161858.625}}}, {{{0.429359489926, 0.1234734}, {0.334602098327, 0.2868496}, {0.161660667619, 0.0528971}, {0.142409059982, 0.6763393}, {0.0361420107952, 1.622252}, {0.00258444353334, 3.5865914}, {0.0000330554296793, 6.8659711}}, {{0.428165504137, 0.1231682}, {0.335337607796, 0.2856899}, {0.161027990901, 0.0528361}, {0.143116586243, 0.6737758}, {0.0362466672267, 1.6092515}, {0.00284410136423, 3.4537789}, {0.0000569310001879, 6.8520551}}, {{0.427319176758, 0.1241753}, {0.331082463419, 0.2861172}, {0.162535821472, 0.0534159}, {0.143323120531, 0.6624232}, {0.0390444891351, 1.5547471}, {0.003520704226, 3.4576852}, {0.0000141823878019, 6.9575238}}, {{0.358098642046, 0.1442864}, {0.32164887466, 0.2873379}, {0.18238450197, 0.6140834}, {0.154897896007, 0.0779215}, {0.0705724184387, 1.4274277}, {0.0150264624111, 3.6046578}, {0.0000903731354154, 18.7646527}}, {{0.58346723708, 0.5685859}, {0.281478132931, 1.0043789}, {0.108104756091, 2.2577119}, {0.0405840683042, 0.4407246}, {0.0330315313469, 5.8134688}, {0.0072867943184, 16.2643359}, {0.000466408793892, 44.4820293}}, {{0.942916351537, 5.1245625}, {0.133342553621, 8.1039062}, {0.104644468016, 5.253125}, {0.0354578743237, 18.2687812}, {0.00937886793245, 48.0672344}, {0.00199228871415, 138.0632812}, {0.000159316832343, 374.3420625}}, {{0.896580799368, 51.7597656}, {0.266443997146, 38.82375}, {0.183957650946, 37.41875}, {0.0214002824563, 123.664375}, {0.00447073575434, 341.1996875}, {0.000918356559293, 1027.5625}, {0.00009695842348, 3014.9875}}, {{0.913862688035, 508.9235352}, {0.121381916992, 420.9912109}, {0.0407513485941, 384.5292969}, {0.00600327087104, 1338.1882813}, {0.00116350803938, 3915.4914063}, {0.00021369500852, 12474.609375}, {0.0000135483561867, 38985.265625}}, {{0.829950903804, 5094.921875}, {0.185718879247, 4525.6855469}, {0.0198603019717, 3499.6875}, {0.00316307320439, 2833.828125}, {0.00135176095495, 16994.96875}, {0.00023895042878, 54521.953125}, {0.0000345186282748, 187210.1875}}}, {{{0.384798093502, 0.1281121}, {0.34921392799, 0.2907559}, {0.176191525149, 0.6665736}, {0.126129675041, 0.056193}, {0.0640303657982, 1.5226426}, {0.0180375911648, 3.3365914}, {0.00336311685394, 6.8659711}}, {{0.384258588441, 0.1281731}, {0.348488101924, 0.2903286}, {0.176475872494, 0.6640102}, {0.126472207193, 0.0562541}, {0.0645142334907, 1.5155015}, {0.0181710381459, 3.3287789}, {0.0033843378, 6.8520551}}, {{0.383367633044, 0.1285698}, {0.348061132856, 0.2907559}, {0.177035702966, 0.6633998}, {0.125950079509, 0.0565897}, {0.0653356922623, 1.5117783}, {0.0187232340992, 3.3326852}, {0.00349779713106, 6.9575238}}, {{0.332095473339, 0.289291}, {0.33128986618, 0.1442864}, {0.207496489154, 0.6140834}, {0.115233090993, 0.0781657}, {0.0956693314804, 1.4215684}, {0.0317612124678, 3.6984078}, {0.0060102301932, 10.7646527}}, {{0.570991493188, 0.5685859}, {0.288028738881, 1.0043789}, {0.114758429753, 2.2546602}, {0.0383354632261, 5.8378828}, {0.0364398234618, 0.4407246}, {0.0105577844963, 17.3385547}, {0.0019305403602, 61.6695293}}, {{0.92882976667, 5.1245625}, {0.135255980745, 8.1039062}, {0.0942398901648, 5.253125}, {0.0369687578779, 18.2687812}, {0.0103765431211, 48.7996562}, {0.00261014033098, 151.246875}, {0.000449703790393, 567.7014375}}, {{0.896524880784, 51.7597656}, {0.263730261373, 38.82375}, {0.181961166743, 37.41875}, {0.0220963781139, 123.664375}, {0.00477789046476, 349.98875}, {0.00107472293582, 1152.5625}, {0.000176889556777, 4702.4875}}, {{0.915062567983, 508.9235352}, {0.115602280213, 420.9912109}, {0.0363085794141, 382.0878906}, {0.00616482467625, 1350.3953125}, {0.00122376722806, 4101.0382813}, {0.000248697365436, 14310.546875}, {0.0000360328341794, 58047.765625}}, {{0.837670478983, 5094.921875}, {0.182732404829, 4486.6230469}, {0.0243418733361, 3577.8125}, {0.0029162033293, 2833.828125}, {0.00138279173414, 17619.96875}, {0.000245788451015, 63662.578125}, {0.0000361002163805, 305803.9375}}}, {{{0.372093277599, 0.1281121}, {0.355105964543, 0.2907559}, {0.186026974077, 0.6665736}, {0.113107832708, 0.0564372}, {0.071931407301, 1.5226426}, {0.0238465800549, 3.4928414}, {0.004791272029, 8.4909711}}, {{0.370995603756, 0.1281731}, {0.354161845411, 0.2898403}, {0.186791755392, 0.6630336}, {0.113567151839, 0.0564982}, {0.0727088907182, 1.5155015}, {0.023940931892, 3.5006539}, {0.00474654115123, 8.5083051}}, {{0.370103023667, 0.1285698}, {0.353390202427, 0.2902676}, {0.187354016991, 0.6614467}, {0.112928932178, 0.0568339}, {0.0741263933138, 1.5117783}, {0.0245582254263, 3.5358102}, {0.00476644895674, 8.7700238}}, {{0.336684797691, 0.2844082}, {0.311828658096, 0.1442864}, {0.226771469594, 0.6218959}, {0.11113562667, 0.0791422}, {0.101129394924, 1.5514512}, {0.0313119787019, 4.4718453}, {0.00573277659989, 15.1865277}}, {{0.544836235184, 0.5685859}, {0.298205127364, 1.0089565}, {0.115778814481, 2.3614717}, {0.0560556170357, 0.4712422}, {0.0366275848016, 6.5275801}, {0.00935922985093, 21.3058398}, {0.00159291808679, 87.8414043}}, {{0.843158049794, 5.1221783}, {0.127192479933, 8.2936874}, {0.0356950016808, 18.1009346}, {0.0110197139722, 46.7549785}, {0.00284966440237, 143.434375}, {0.000577779350853, 492.9944062}, {0.0000723776790016, 1731.815625}}, {{0.900665700571, 51.7597656}, {0.224131540382, 38.5796094}, {0.146080034148, 36.9304688}, {0.0219794621522, 126.1057813}, {0.00464679661951, 370.4965625}, {0.00100500689704, 1306.859375}, {0.00015802625107, 6100.925}}, {{0.815274612759, 508.9235352}, {0.177638831637, 474.8547363}, {0.00733082662703, 1217.590332}, {0.00143689281613, 3603.8132812}, {0.000307888874689, 11732.8742187}, {0.0000610632772395, 40850.8378906}, {8.42544183884*10^-6, 147930.578125}}, {{0.982928716205, 5094.9099541}, {0.0461343177829, 3577.8125}, {0.0347146843875, 8197.3888855}, {0.0166022240915, 10432.46875}, {0.0106375615383, 2833.828125}, {0.000297741912999, 62962.140625}, {0.0000331556612543, 377295.390625}}}, {{{0.359814719308, 0.1281121}, {0.359342503096, 0.2902676}, {0.195950085406, 0.6665736}, {0.102759163534, 0.0566813}, {0.0808986208921, 1.5577988}, {0.0275548897843, 3.8990914}, {0.00553653289443, 11.0378461}}, {{0.359315107253, 0.1281731}, {0.358555541743, 0.2898403}, {0.196200521459, 0.6640102}, {0.103059845326, 0.0567423}, {0.0814579200801, 1.5506577}, {0.027728207148, 3.8912789}, {0.0055445139839, 11.0395551}}, {{0.356793590365, 0.1295464}, {0.355606392262, 0.2907559}, {0.197207538959, 0.6624232}, {0.105732915841, 0.0578104}, {0.0833583459554, 1.5547471}, {0.0280772953627, 3.9772164}, {0.00553751111279, 11.5356488}}, {{0.375221450433, 0.2919766}, {0.314949991955, 0.138427}, {0.229824357845, 0.6990443}, {0.0913882168201, 1.8942246}, {0.0867174508736, 0.0762125}, {0.0260415623272, 5.9777047}, {0.0046294166067, 23.4521527}}, {{0.610478049261, 0.5592399}, {0.301830233077, 1.0575939}, {0.0981280793202, 2.4469209}, {0.036247865954, 5.6059492}, {0.0130704107983, 15.306084}, {0.00311337493686, 52.0276387}, {0.000517468899106, 207.7632793}}, {{0.843433421888, 5.123132}, {0.127006070867, 8.3118073}, {0.0358582305776, 18.2230049}, {0.0109843463578, 47.8230937}, {0.00281754415371, 150.2703125}, {0.000585344094836, 544.2639375}, {0.000086389742419, 2278.690625}}, {{0.906665567085, 51.7750244}, {0.292168274549, 37.6030469}, {0.219315296667, 36.4421875}, {0.0215690080083, 129.7678906}, {0.00441860463352, 396.86375}, {0.000914268516369, 1480.6875}, {0.000140811184359, 7671.2375}}, {{0.830190399036, 508.9235352}, {0.163068306296, 472.4133301}, {0.00712245329878, 1260.0097656}, {0.00133424976015, 3845.5125}, {0.000265893224918, 11810.9992187}, {0.0000757019992133, 32100.8378906}, {0.0000185670530404, 127930.578125}}, {{0.982865601367, 5094.9165106}, {0.0461813244802, 3577.8125}, {0.0346578247281, 8197.3888855}, {0.0165765894882, 10432.46875}, {0.0106550290677, 2833.828125}, {0.00030275875818, 62649.640625}, {0.0000353944344536, 390850.078125}}}, {{{0.358020655653, 0.2907559}, {0.352737953939, 0.1290886}, {0.203917129252, 0.6665736}, {0.0992183370561, 0.0572917}, {0.0879867932419, 1.6242051}, {0.0280612550513, 4.4850289}, {0.00521772877477, 14.3034711}}, {{0.354716929531, 0.2873989}, {0.348194618224, 0.1291497}, {0.206493544323, 0.653268}, {0.100979651735, 0.0577189}, {0.0902382442762, 1.585814}, {0.0291410618407, 4.3834664}, {0.00538769987782, 14.1645551}}, {{0.360906280962, 0.289291}, {0.348872112157, 0.1285698}, {0.207851980278, 0.6692592}, {0.0965691494812, 0.0573222}, {0.0885936311838, 1.6563096}, {0.0279181195882, 4.6647164}, {0.0051385208873, 15.3637738}}, {{0.399672265683, 0.3063809}, {0.341425011171, 0.1345208}, {0.222542202677, 0.781808}, {0.0812142464405, 2.2399277}, {0.0605167915589, 0.0698649}, {0.0218135353762, 7.4874703}, {0.00386709220729, 32.4521527}}, {{0.6142495966, 0.560289}, {0.303174206959, 1.0720898}, {0.0995146625432, 2.5865388}, {0.0329436741245, 6.4161909}, {0.0109098753364, 18.1075977}, {0.00260695446889, 64.259084}, {0.000420705123361, 291.9429668}}, {{0.842471902156, 5.1221783}, {0.127906416743, 8.2946411}, {0.0361281494645, 18.2992988}, {0.0109342891613, 48.6775859}, {0.00277882762652, 157.10625}, {0.000559630812339, 605.787375}, {0.0000834890880658, 2864.628125}}, {{0.910331826498, 51.7750244}, {0.0837230048492, 39.371875}, {0.0212324575337, 133.1858594}, {0.0138592267668, 31.6216016}, {0.00419068891211, 421.2778125}, {0.000842252255897, 1634.0078125}, {0.00012360831152, 9241.55}}, {{0.821185276032, 508.9235352}, {0.171842183079, 473.939209}, {0.00725589756691, 1232.8491211}, {0.00138899413267, 3640.8332031}, {0.000291893959039, 10500.7859375}, {0.0000963321030082, 28702.4003906}, {0.0000218459547552, 130508.703125}}, {{0.983238498148, 5094.921279}, {0.04595783156, 3577.8125}, {0.034671911615, 8168.2636719}, {0.0163682623015, 10432.430603}, {0.0105810376255, 2833.828125}, {0.000304501431224, 63245.34375}, {0.0000348424152977, 414600.078125}}}}; 
for example but it didn't work. In fact I always have problem with flattening the nested list. I would be so grateful if someone helps me to solve my problem and also suggest a simple and general way to flatten nested lists. Thanks in advance.

I tried Splice for example but it didn't work. In fact I always have problem with flattening the nested list. I would be so grateful if someone helps me to solve my problem and also suggest a simple and general way to flatten nested lists. Thanks in advance. I put my original matrix so that everyone can play with it and find a solution:

matcoeffE={{{{0.337105218393, 0.056193}, {0.294455728512, 0.0324089}, {0.229748751017, 0.0240914}, {0.119148671044, 0.0142299}, {0.0664237134392, 0.1101117}, {0.00360028488651, 0.0070176}, {0.00321876229242, 0.0095059}}, {{0.374477003626, 0.0403286}, {0.29370920304, 0.0250041}, {0.209377864083, 0.0702602}, {0.131720218978, 0.0155015}, {0.0285694972792, 0.1281731}, {0.00863878243626, 0.0084664}, {0.000774968910065, 0.1645551}}, {{0.353907169894, 0.0501186}, {0.282474762619, 0.0214335}, {0.24538956531, 0.0329434}, {0.122729046207, 0.0934136}, {0.0374967404997, 0.0117783}, {0.00409111482812, 0.2076852}, {0.000475343415407, 0.2700238}}, {{0.53811512475, 0.0742594}, {0.170318148036, 0.05256}, {0.161678229565, 0.1208489}, {0.141656495447, 0.1554391}, {0.035514890258, 0.4215684}, {0.0289076045686, 0.5146527}, {0.00613051478656, 0.664291}}, {{0.713827443266, 0.5416797}, {0.115140609435, 0.4651387}, {0.102812097576, 0.7638984}, {0.0707016321359, 1.0043789}, {0.00599167476141, 1.9316328}, {0.000637054993659, 3.8171602}, {0.000189278672094, 5.4195293}}, {{0.835519060786, 5.1245625}, {0.107002120313, 4.7648438}, {0.0582202117269, 7.9818359}, {0.00235609532767, 19.733625}, {0.000883428336476, 36.1043437}, {0.000591486899281, 59.8889375}, {0.000274137306624, 73.121875}}, {{0.797822870474, 51.7597656}, {0.238092217028, 44.683125}, {0.0395767606479, 39.371875}, {0.00675078217198, 127.570625}, {0.00247722719796, 165.378125}, {0.000421934277043, 346.0825}, {0.00023532357072, 402.5625}}, {{0.814777900984, 508.4657715}, {0.188879629401, 469.8193359}, {0.00471773717827, 372.3222656}, {0.00144832509778, 1205.078125}, {0.000669589290873, 2717.5828125}, {0.000558343657888, 3008.703125}, {0.0000245903493125, 5038.5382812}}, {{0.772879788376, 5094.921875}, {0.243590194039, 4643.1782227}, {0.0193061267018, 3577.8125}, {0.00287759315129, 2833.828125}, {0.0000534470768605, 26213.71875}, {0.0000145819727195, 45381.328125}, {3.09771296336*10^-7, 312053.9375}}}, {{{0.303693119093, 0.056193}, {0.237265518175, 0.0382683}, {0.225650952584, 0.0251309}, {0.199797160722, 0.0944867}, {0.0463135246782, 0.0142299}, {0.0404471019324, 0.1725289}, {0.000100058428638, 0.7570176}}, {{0.3487394747, 0.0403286}, {0.321833428752, 0.0702602}, {0.201142045915, 0.0259806}, {0.107900509321, 0.1281731}, {0.067034074849, 0.0155015}, {0.00699454832318, 0.2584664}, {0.000420629669261, 0.4145551}}, {{0.389207013526, 0.0501186}, {0.246897089573, 0.0934136}, {0.206279490703, 0.0329434}, {0.161545603996, 0.0214335}, {0.0302243453964, 0.1762738}, {0.0111093028478, 0.0117783}, {0.00686831864122, 0.2076852}}, {{0.467275250226, 0.0742594}, {0.238329871874, 0.1208489}, {0.143000989862, 0.1554391}, {0.110382195975, 0.05256}, {0.0705097318499, 0.2646527}, {0.00253376493807, 0.4215684}, {0.000606394390292, 0.664291}}, {{0.661617883744, 0.5416797}, {0.167695730963, 0.7638984}, {0.0963091905633, 0.4651387}, {0.0730772755963, 1.1293789}, {0.0138145655973, 1.9316328}, {0.000466639107665, 2.8171602}, {0.0000509136064617, 5.4195293}}, {{0.833373633549, 5.1245625}, {0.0881514708645, 4.7648438}, {0.0757376260069, 7.9818359}, {0.0302202976214, 19.733625}, {0.024001912395, 21.1043437}, {0.000584143658157, 37.8889375}, {0.0000458966960018, 73.121875}}, {{0.808173208638, 51.7597656}, {0.213868587962, 44.683125}, {0.0297655773869, 38.871875}, {0.00962316567181, 114.070625}, {0.000770644945905, 165.378125}, {0.000381591000288, 346.0825}, {0.000218506763466, 402.5625}}, {{0.789951387113, 509.9657715}, {0.213562199711, 469.8193359}, {0.00543519745044, 372.3222656}, {0.00244143032211, 1205.078125}, {0.000628846880473, 2717.5828125}, {0.000545617803204, 3008.703125}, {0.0000261195944445, 5038.5382812}}, {{0.66288560564, 5145.921875}, {0.360079344396, 4679.6782227}, {0.0260887078954, 3643.3125}, {0.00314613005764, 2833.828125}, {0.000147724072458, 26213.71875}, {0.0000403274425436, 45381.328125}, {9.02172204944*10^-7, 312053.9375}}}, {{{0.456673392295, 0.056193}, {0.258334129604, 0.1139352}, {0.168974465005, 0.0265488}, {0.116200808341, 0.0324089}, {0.091569239737, 0.2663617}, {0.0597554437238, 0.2798549}, {0.0257414513917, 0.0143887}}, {{0.362058141104, 0.0702602}, {0.323306909966, 0.0403286}, {0.163083648542, 0.1281731}, {0.140755713588, 0.0250041}, {0.0308223560747, 0.0155015}, {0.0196061024677, 0.2584664}, {0.0180816953095, 0.1645551}}, {{0.343491769209, 0.0816948}, {0.302903894711, 0.0462123}, {0.184131308012, 0.0329434}, {0.104983036389, 0.1450238}, {0.0866389972346, 0.0194804}, {0.0321899670767, 0.2076852}, {0.00249590630902, 0.3867783}}, {{0.416161799777, 0.0742594}, {0.266438030108, 0.1208489}, {0.151243489211, 0.1554391}, {0.115793451563, 0.2646527}, {0.0800396617974, 0.05256}, {0.0113880779019, 0.5465684}, {0.00226355745604, 0.664291}}, {{0.636158131055, 0.5416797}, {0.185603576845, 0.7638984}, {0.0864661704891, 1.1293789}, {0.0816704302792, 0.4651387}, {0.0249952757516, 1.9316328}, {0.000470472578609, 3.9195293}, {0.000149374893022, 2.8171602}}, {{0.876501207045, 5.1245625}, {0.0812088920302, 8.0443359}, {0.0353647420904, 4.5148438}, {0.0150844928412, 16.733625}, {0.00318514994609, 21.1043437}, {0.000361526580091, 37.8889375}, {0.0000304850860559, 73.121875}}, {{0.808918112296, 51.7597656}, {0.191323721264, 45.183125}, {0.0116345008524, 110.070625}, {0.0109048358399, 36.371875}, {0.000528105573106, 165.378125}, {0.000497606911561, 346.0825}, {0.000276209166924, 402.5625}}, {{0.783915149687, 510.4657715}, {0.218901576865, 469.8193359}, {0.00544727538068, 372.3222656}, {0.00318807233467, 1204.078125}, {0.00040015456217, 3008.703125}, {0.000384757210729, 2717.5828125}, {0.0000243018304851, 5038.5382812}}, {{1.00875018249, 4958.1782227}, {0.0322092150795, 4195.8125}, {0.0224685283176, 6361.421875}, {0.00102487623067, 2842.328125}, {0.000179911273948, 26211.21875}, {0.0000405811030711, 45381.328125}, {8.13557423522*10^-7, 312053.9375}}}, {{{0.354225109934, 0.0886273}, {0.347694634477, 0.0480339}, {0.153259978948, 0.1548549}, {0.108547604664, 0.0288493}, {0.0594071950625, 0.2506539}, {0.0362035984726, 0.0192715}, {0.00489664460763, 0.4757676}}, {{0.665440342079, 0.0481411}, {0.432156202277, 0.0812981}, {0.373920820155, 0.0546352}, {0.198431750515, 0.1567426}, {0.100346601871, 0.0228068}, {0.0403149432067, 0.2975289}, {0.00142436173149, 0.5155015}}, {{0.415859312055, 0.0501186}, {0.379262000676, 0.1012261}, {0.133129803922, 0.2076852}, {0.125231739592, 0.0251309}, {0.00947725176645, 0.4433085}, {0.000864683621561, 0.0078721}, {0.000162087287215, 1.0200238}}, {{0.347997596392, 0.0742594}, {0.283654206546, 0.1208489}, {0.168749255129, 0.2646527}, {0.162487385284, 0.1554391}, {0.0504259956017, 0.05256}, {0.0293915458282, 0.4840684}, {0.00507051288577, 0.664291}}, {{0.58108030387, 0.5416797}, {0.159793269513, 0.7013984}, {0.15688374963, 1.0043789}, {0.0699065610027, 0.4651387}, {0.0503789896472, 1.9316328}, {0.00621350227585, 4.8171602}, {0.00337305714118, 5.4195293}}, {{0.879185520379, 5.1245625}, {0.0889620446086, 7.9818359}, {0.0169631948878, 14.233625}, {0.0165662900907, 4.2648437}, {0.00516769019762, 21.1043437}, {0.000525986662014, 37.8889375}, {0.0000224399831243, 73.121875}}, {{0.767443534729, 51.7597656}, {0.219497383273, 46.433125}, {0.0155287979558, 97.570625}, {0.0041321881041, 34.871875}, {0.00362692308715, 165.378125}, {0.00078489199258, 346.0825}, {0.000345891085312, 402.5625}}, {{0.768734743394, 511.4657715}, {0.233659618215, 469.8193359}, {0.00591859518444, 372.3222656}, {0.00401755489527, 1204.078125}, {0.000203786465613, 2717.5828125}, {0.0000857443745085, 3008.703125}, {0.0000149068779031, 5038.5382812}}, {{0.760091509734, 5137.421875}, {0.288560985837, 4475.6782227}, {0.0538484983699, 3685.8125}, {0.00507009636824, 2834.828125}, {0.000416893433163, 22866.21875}, {0.0000476392864995, 45381.328125}, {1.30052394563*10^-6, 312053.9375}}}, {{{0.386310196382, 0.0865914}, {0.332921941423, 0.1755414}, {0.17799338315, 0.0435268}, {0.149176901113, 0.370834}, {0.0268601560027, 0.8058457}, {0.0260656953947, 0.0226433}, {0.0153671284924, 0.024943}}, {{2.4389171684, 0.099557}, {2.26291328993, 0.1062466}, {0.577556664253, 0.158857}, {0.156752671205, 0.0381876}, {0.115925798297, 0.3645012}, {0.0417176216582, 0.4790082}, {0.0158043546084, 0.9237046}}, {{0.368284183893, 0.0660698}, {0.337652880227, 0.1321498}, {0.18636442394, 0.2270551}, {0.125561165854, 0.0348965}, {0.115291016596, 0.4141221}, {0.070199225543, 0.044871}, {0.0207326379841, 0.8678414}}, {{0.404385576213, 0.1442864}, {0.279658644019, 0.0781657}, {0.270632806944, 0.289291}, {0.106757016301, 0.6140834}, {0.0178552809682, 1.3278184}, {0.0152041146993, 0.0734078}, {0.0099348901018, 0.0459027}}, {{0.630183333641, 0.5685859}, {0.249413630792, 1.0043789}, {0.0824630587623, 2.1530977}, {0.0547586565779, 0.4407246}, {0.0179446476122, 4.7632793}, {0.00268580196679, 7.3378828}, {0.000401744299572, 13.3385547}}, {{0.763211159584, 5.1245625}, {0.122275801622, 8.1039062}, {0.0930888641154, 4.9601563}, {0.0295539126242, 18.2687812}, {0.00535171560314, 47.6277812}, {0.0000583299326326, 251.246875}, {0.0000134622249122, 567.7014375}}, {{0.884282647609, 51.7597656}, {0.200545237693, 40.2885938}, {0.103232341157, 37.9070313}, {0.0191926673242, 120.9788281}, {0.00335627673797, 316.2973437}, {0.000281407246197, 816.625}, {0.0000121400209066, 1702.4875}}, {{0.894552850514, 508.9235352}, {0.152363094041, 433.1982422}, {0.0521240828822, 401.6191406}, {0.00562321358454, 1252.7390625}, {0.00121335266996, 3526.28125}, {0.000330439413787, 4413.5382813}, {0.000110608388206, 7435.546875}}, {{0.833736706984, 5094.8980331}, {0.184572645005, 4498.8300781}, {0.0231764470276, 3480.15625}, {0.00406145097323, 2833.828125}, {0.00111080643037, 16863.1328125}, {0.000141094300912, 47646.953125}, {1.17585428566*10^-6, 161858.625}}}, {{{0.429359489926, 0.1234734}, {0.334602098327, 0.2868496}, {0.161660667619, 0.0528971}, {0.142409059982, 0.6763393}, {0.0361420107952, 1.622252}, {0.00258444353334, 3.5865914}, {0.0000330554296793, 6.8659711}}, {{0.428165504137, 0.1231682}, {0.335337607796, 0.2856899}, {0.161027990901, 0.0528361}, {0.143116586243, 0.6737758}, {0.0362466672267, 1.6092515}, {0.00284410136423, 3.4537789}, {0.0000569310001879, 6.8520551}}, {{0.427319176758, 0.1241753}, {0.331082463419, 0.2861172}, {0.162535821472, 0.0534159}, {0.143323120531, 0.6624232}, {0.0390444891351, 1.5547471}, {0.003520704226, 3.4576852}, {0.0000141823878019, 6.9575238}}, {{0.358098642046, 0.1442864}, {0.32164887466, 0.2873379}, {0.18238450197, 0.6140834}, {0.154897896007, 0.0779215}, {0.0705724184387, 1.4274277}, {0.0150264624111, 3.6046578}, {0.0000903731354154, 18.7646527}}, {{0.58346723708, 0.5685859}, {0.281478132931, 1.0043789}, {0.108104756091, 2.2577119}, {0.0405840683042, 0.4407246}, {0.0330315313469, 5.8134688}, {0.0072867943184, 16.2643359}, {0.000466408793892, 44.4820293}}, {{0.942916351537, 5.1245625}, {0.133342553621, 8.1039062}, {0.104644468016, 5.253125}, {0.0354578743237, 18.2687812}, {0.00937886793245, 48.0672344}, {0.00199228871415, 138.0632812}, {0.000159316832343, 374.3420625}}, {{0.896580799368, 51.7597656}, {0.266443997146, 38.82375}, {0.183957650946, 37.41875}, {0.0214002824563, 123.664375}, {0.00447073575434, 341.1996875}, {0.000918356559293, 1027.5625}, {0.00009695842348, 3014.9875}}, {{0.913862688035, 508.9235352}, {0.121381916992, 420.9912109}, {0.0407513485941, 384.5292969}, {0.00600327087104, 1338.1882813}, {0.00116350803938, 3915.4914063}, {0.00021369500852, 12474.609375}, {0.0000135483561867, 38985.265625}}, {{0.829950903804, 5094.921875}, {0.185718879247, 4525.6855469}, {0.0198603019717, 3499.6875}, {0.00316307320439, 2833.828125}, {0.00135176095495, 16994.96875}, {0.00023895042878, 54521.953125}, {0.0000345186282748, 187210.1875}}}, {{{0.384798093502, 0.1281121}, {0.34921392799, 0.2907559}, {0.176191525149, 0.6665736}, {0.126129675041, 0.056193}, {0.0640303657982, 1.5226426}, {0.0180375911648, 3.3365914}, {0.00336311685394, 6.8659711}}, {{0.384258588441, 0.1281731}, {0.348488101924, 0.2903286}, {0.176475872494, 0.6640102}, {0.126472207193, 0.0562541}, {0.0645142334907, 1.5155015}, {0.0181710381459, 3.3287789}, {0.0033843378, 6.8520551}}, {{0.383367633044, 0.1285698}, {0.348061132856, 0.2907559}, {0.177035702966, 0.6633998}, {0.125950079509, 0.0565897}, {0.0653356922623, 1.5117783}, {0.0187232340992, 3.3326852}, {0.00349779713106, 6.9575238}}, {{0.332095473339, 0.289291}, {0.33128986618, 0.1442864}, {0.207496489154, 0.6140834}, {0.115233090993, 0.0781657}, {0.0956693314804, 1.4215684}, {0.0317612124678, 3.6984078}, {0.0060102301932, 10.7646527}}, {{0.570991493188, 0.5685859}, {0.288028738881, 1.0043789}, {0.114758429753, 2.2546602}, {0.0383354632261, 5.8378828}, {0.0364398234618, 0.4407246}, {0.0105577844963, 17.3385547}, {0.0019305403602, 61.6695293}}, {{0.92882976667, 5.1245625}, {0.135255980745, 8.1039062}, {0.0942398901648, 5.253125}, {0.0369687578779, 18.2687812}, {0.0103765431211, 48.7996562}, {0.00261014033098, 151.246875}, {0.000449703790393, 567.7014375}}, {{0.896524880784, 51.7597656}, {0.263730261373, 38.82375}, {0.181961166743, 37.41875}, {0.0220963781139, 123.664375}, {0.00477789046476, 349.98875}, {0.00107472293582, 1152.5625}, {0.000176889556777, 4702.4875}}, {{0.915062567983, 508.9235352}, {0.115602280213, 420.9912109}, {0.0363085794141, 382.0878906}, {0.00616482467625, 1350.3953125}, {0.00122376722806, 4101.0382813}, {0.000248697365436, 14310.546875}, {0.0000360328341794, 58047.765625}}, {{0.837670478983, 5094.921875}, {0.182732404829, 4486.6230469}, {0.0243418733361, 3577.8125}, {0.0029162033293, 2833.828125}, {0.00138279173414, 17619.96875}, {0.000245788451015, 63662.578125}, {0.0000361002163805, 305803.9375}}}, {{{0.372093277599, 0.1281121}, {0.355105964543, 0.2907559}, {0.186026974077, 0.6665736}, {0.113107832708, 0.0564372}, {0.071931407301, 1.5226426}, {0.0238465800549, 3.4928414}, {0.004791272029, 8.4909711}}, {{0.370995603756, 0.1281731}, {0.354161845411, 0.2898403}, {0.186791755392, 0.6630336}, {0.113567151839, 0.0564982}, {0.0727088907182, 1.5155015}, {0.023940931892, 3.5006539}, {0.00474654115123, 8.5083051}}, {{0.370103023667, 0.1285698}, {0.353390202427, 0.2902676}, {0.187354016991, 0.6614467}, {0.112928932178, 0.0568339}, {0.0741263933138, 1.5117783}, {0.0245582254263, 3.5358102}, {0.00476644895674, 8.7700238}}, {{0.336684797691, 0.2844082}, {0.311828658096, 0.1442864}, {0.226771469594, 0.6218959}, {0.11113562667, 0.0791422}, {0.101129394924, 1.5514512}, {0.0313119787019, 4.4718453}, {0.00573277659989, 15.1865277}}, {{0.544836235184, 0.5685859}, {0.298205127364, 1.0089565}, {0.115778814481, 2.3614717}, {0.0560556170357, 0.4712422}, {0.0366275848016, 6.5275801}, {0.00935922985093, 21.3058398}, {0.00159291808679, 87.8414043}}, {{0.843158049794, 5.1221783}, {0.127192479933, 8.2936874}, {0.0356950016808, 18.1009346}, {0.0110197139722, 46.7549785}, {0.00284966440237, 143.434375}, {0.000577779350853, 492.9944062}, {0.0000723776790016, 1731.815625}}, {{0.900665700571, 51.7597656}, {0.224131540382, 38.5796094}, {0.146080034148, 36.9304688}, {0.0219794621522, 126.1057813}, {0.00464679661951, 370.4965625}, {0.00100500689704, 1306.859375}, {0.00015802625107, 6100.925}}, {{0.815274612759, 508.9235352}, {0.177638831637, 474.8547363}, {0.00733082662703, 1217.590332}, {0.00143689281613, 3603.8132812}, {0.000307888874689, 11732.8742187}, {0.0000610632772395, 40850.8378906}, {8.42544183884*10^-6, 147930.578125}}, {{0.982928716205, 5094.9099541}, {0.0461343177829, 3577.8125}, {0.0347146843875, 8197.3888855}, {0.0166022240915, 10432.46875}, {0.0106375615383, 2833.828125}, {0.000297741912999, 62962.140625}, {0.0000331556612543, 377295.390625}}}, {{{0.359814719308, 0.1281121}, {0.359342503096, 0.2902676}, {0.195950085406, 0.6665736}, {0.102759163534, 0.0566813}, {0.0808986208921, 1.5577988}, {0.0275548897843, 3.8990914}, {0.00553653289443, 11.0378461}}, {{0.359315107253, 0.1281731}, {0.358555541743, 0.2898403}, {0.196200521459, 0.6640102}, {0.103059845326, 0.0567423}, {0.0814579200801, 1.5506577}, {0.027728207148, 3.8912789}, {0.0055445139839, 11.0395551}}, {{0.356793590365, 0.1295464}, {0.355606392262, 0.2907559}, {0.197207538959, 0.6624232}, {0.105732915841, 0.0578104}, {0.0833583459554, 1.5547471}, {0.0280772953627, 3.9772164}, {0.00553751111279, 11.5356488}}, {{0.375221450433, 0.2919766}, {0.314949991955, 0.138427}, {0.229824357845, 0.6990443}, {0.0913882168201, 1.8942246}, {0.0867174508736, 0.0762125}, {0.0260415623272, 5.9777047}, {0.0046294166067, 23.4521527}}, {{0.610478049261, 0.5592399}, {0.301830233077, 1.0575939}, {0.0981280793202, 2.4469209}, {0.036247865954, 5.6059492}, {0.0130704107983, 15.306084}, {0.00311337493686, 52.0276387}, {0.000517468899106, 207.7632793}}, {{0.843433421888, 5.123132}, {0.127006070867, 8.3118073}, {0.0358582305776, 18.2230049}, {0.0109843463578, 47.8230937}, {0.00281754415371, 150.2703125}, {0.000585344094836, 544.2639375}, {0.000086389742419, 2278.690625}}, {{0.906665567085, 51.7750244}, {0.292168274549, 37.6030469}, {0.219315296667, 36.4421875}, {0.0215690080083, 129.7678906}, {0.00441860463352, 396.86375}, {0.000914268516369, 1480.6875}, {0.000140811184359, 7671.2375}}, {{0.830190399036, 508.9235352}, {0.163068306296, 472.4133301}, {0.00712245329878, 1260.0097656}, {0.00133424976015, 3845.5125}, {0.000265893224918, 11810.9992187}, {0.0000757019992133, 32100.8378906}, {0.0000185670530404, 127930.578125}}, {{0.982865601367, 5094.9165106}, {0.0461813244802, 3577.8125}, {0.0346578247281, 8197.3888855}, {0.0165765894882, 10432.46875}, {0.0106550290677, 2833.828125}, {0.00030275875818, 62649.640625}, {0.0000353944344536, 390850.078125}}}, {{{0.358020655653, 0.2907559}, {0.352737953939, 0.1290886}, {0.203917129252, 0.6665736}, {0.0992183370561, 0.0572917}, {0.0879867932419, 1.6242051}, {0.0280612550513, 4.4850289}, {0.00521772877477, 14.3034711}}, {{0.354716929531, 0.2873989}, {0.348194618224, 0.1291497}, {0.206493544323, 0.653268}, {0.100979651735, 0.0577189}, {0.0902382442762, 1.585814}, {0.0291410618407, 4.3834664}, {0.00538769987782, 14.1645551}}, {{0.360906280962, 0.289291}, {0.348872112157, 0.1285698}, {0.207851980278, 0.6692592}, {0.0965691494812, 0.0573222}, {0.0885936311838, 1.6563096}, {0.0279181195882, 4.6647164}, {0.0051385208873, 15.3637738}}, {{0.399672265683, 0.3063809}, {0.341425011171, 0.1345208}, {0.222542202677, 0.781808}, {0.0812142464405, 2.2399277}, {0.0605167915589, 0.0698649}, {0.0218135353762, 7.4874703}, {0.00386709220729, 32.4521527}}, {{0.6142495966, 0.560289}, {0.303174206959, 1.0720898}, {0.0995146625432, 2.5865388}, {0.0329436741245, 6.4161909}, {0.0109098753364, 18.1075977}, {0.00260695446889, 64.259084}, {0.000420705123361, 291.9429668}}, {{0.842471902156, 5.1221783}, {0.127906416743, 8.2946411}, {0.0361281494645, 18.2992988}, {0.0109342891613, 48.6775859}, {0.00277882762652, 157.10625}, {0.000559630812339, 605.787375}, {0.0000834890880658, 2864.628125}}, {{0.910331826498, 51.7750244}, {0.0837230048492, 39.371875}, {0.0212324575337, 133.1858594}, {0.0138592267668, 31.6216016}, {0.00419068891211, 421.2778125}, {0.000842252255897, 1634.0078125}, {0.00012360831152, 9241.55}}, {{0.821185276032, 508.9235352}, {0.171842183079, 473.939209}, {0.00725589756691, 1232.8491211}, {0.00138899413267, 3640.8332031}, {0.000291893959039, 10500.7859375}, {0.0000963321030082, 28702.4003906}, {0.0000218459547552, 130508.703125}}, {{0.983238498148, 5094.921279}, {0.04595783156, 3577.8125}, {0.034671911615, 8168.2636719}, {0.0163682623015, 10432.430603}, {0.0105810376255, 2833.828125}, {0.000304501431224, 63245.34375}, {0.0000348424152977, 414600.078125}}}}; 

I tried Splice for example but it didn't work. In fact I always have problem with flattening the nested list. I would be so grateful if someone helps me to solve my problem and also suggest a simple and general way to flatten nested lists. Thanks in advance.

added 133 characters in body
Source Link
Wisdom
  • 1.3k
  • 7
  • 17

so dimensions of newmat became {90, 7, 2}. After that I have to flatten 2 (2*90) and get a new matrix which dimenstions {180,7}which produces an excel file with 190 rows and 7 columns (in a single sheet). My mean is: newmat has 90 rows and 7 columns which each column has two numbers in it . I want to second number of each this two-member list goes to the next row (namely each second member is placed under the first member) so that the dimensions will be {180,7} I tried show my mean schematically as follows: enter image description here

so dimensions of newmat became {90, 7, 2}. After that I have to flatten 2 (2*90) and get a new matrix which dimenstions {180,7}which produces an excel file with 190 rows and 7 columns (in a single sheet). My mean is: newmat has 90 rows and 7 columns which each column has two numbers in it . I want to second number of each this two-member list goes to the next row (namely each second member is placed under the first member) so that the dimensions will be {180,7}

so dimensions of newmat became {90, 7, 2}. After that I have to flatten 2 (2*90) and get a new matrix which dimenstions {180,7}which produces an excel file with 190 rows and 7 columns (in a single sheet). My mean is: newmat has 90 rows and 7 columns which each column has two numbers in it . I want to second number of each this two-member list goes to the next row (namely each second member is placed under the first member) so that the dimensions will be {180,7} I tried show my mean schematically as follows: enter image description here

added 271 characters in body
Source Link
Wisdom
  • 1.3k
  • 7
  • 17
Loading
Source Link
Wisdom
  • 1.3k
  • 7
  • 17
Loading