API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
103
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.26 KB | None | 0 0
raw download clone embed print report
  1. ={
  2. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D3,"|"),6),"|"));
  3. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D4,"|"),6),"|"));
  4. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D5,"|"),6),"|"));
  5. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D6,"|"),6),"|"));
  6. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D7,"|"),6),"|"));
  7. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D8,"|"),6),"|"));
  8. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D9,"|"),6),"|"));
  9. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D10,"|"),6),"|"));
  10. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D11,"|"),6),"|"));
  11. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D12,"|"),6),"|"));
  12. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D13,"|"),6),"|"));
  13. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D14,"|"),6),"|"));
  14. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D15,"|"),6),"|"));
  15. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D16,"|"),6),"|"));
  16. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D17,"|"),6),"|"));
  17. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D18,"|"),6),"|"));
  18. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D19,"|"),6),"|"));
  19. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D20,"|"),6),"|"));
  20. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D21,"|"),6),"|"));
  21. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D22,"|"),6),"|"));
  22. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D23,"|"),6),"|"));
  23. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D24,"|"),6),"|"));
  24. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D25,"|"),6),"|"));
  25. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D26,"|"),6),"|"));
  26.  
  27. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D3,"|"),6),"|"));
  28. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D4,"|"),6),"|"));
  29. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D5,"|"),6),"|"));
  30. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D6,"|"),6),"|"));
  31. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D7,"|"),6),"|"));
  32. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D8,"|"),6),"|"));
  33. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D9,"|"),6),"|"));
  34. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D10,"|"),6),"|"));
  35. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D11,"|"),6),"|"));
  36. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D12,"|"),6),"|"));
  37. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D13,"|"),6),"|"));
  38. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D14,"|"),6),"|"));
  39. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D15,"|"),6),"|"));
  40. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D16,"|"),6),"|"));
  41. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D17,"|"),6),"|"));
  42. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D18,"|"),6),"|"));
  43. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D19,"|"),6),"|"));
  44. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D20,"|"),6),"|"));
  45. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D21,"|"),6),"|"));
  46. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D22,"|"),6),"|"));
  47. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D23,"|"),6),"|"));
  48. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D24,"|"),6),"|"));
  49. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D25,"|"),6),"|"));
  50. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D26,"|"),6),"|"));
  51.  
  52. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D3,"|"),6),"|"));
  53. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D4,"|"),6),"|"));
  54. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D5,"|"),6),"|"));
  55. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D6,"|"),6),"|"));
  56. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D7,"|"),6),"|"));
  57. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D8,"|"),6),"|"));
  58. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D9,"|"),6),"|"));
  59. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D10,"|"),6),"|"));
  60. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D11,"|"),6),"|"));
  61. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D12,"|"),6),"|"));
  62. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D13,"|"),6),"|"));
  63. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D14,"|"),6),"|"));
  64. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D15,"|"),6),"|"));
  65. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D16,"|"),6),"|"));
  66. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D17,"|"),6),"|"));
  67. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D18,"|"),6),"|"));
  68. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D19,"|"),6),"|"));
  69. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D20,"|"),6),"|"));
  70. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D21,"|"),6),"|"));
  71. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D22,"|"),6),"|"));
  72. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D23,"|"),6),"|"));
  73. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D24,"|"),6),"|"));
  74. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D25,"|"),6),"|"));
  75. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D26,"|"),6),"|"));
  76.  
  77. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D3,"|"),6),"|"));
  78. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D4,"|"),6),"|"));
  79. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D5,"|"),6),"|"));
  80. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D6,"|"),6),"|"));
  81. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D7,"|"),6),"|"));
  82. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D8,"|"),6),"|"));
  83. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D9,"|"),6),"|"));
  84. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D10,"|"),6),"|"));
  85. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D11,"|"),6),"|"));
  86. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D12,"|"),6),"|"));
  87. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D13,"|"),6),"|"));
  88. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D14,"|"),6),"|"));
  89. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D15,"|"),6),"|"));
  90. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D16,"|"),6),"|"));
  91. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D17,"|"),6),"|"));
  92. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D18,"|"),6),"|"));
  93. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D19,"|"),6),"|"));
  94. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D20,"|"),6),"|"));
  95. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D21,"|"),6),"|"));
  96. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D22,"|"),6),"|"));
  97. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D23,"|"),6),"|"));
  98. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D24,"|"),6),"|"));
  99. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D25,"|"),6),"|"));
  100. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D26,"|"),6),"|"));
  101.  
  102. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D3,"|"),6),"|"));
  103. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D4,"|"),6),"|"));
  104. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D5,"|"),6),"|"));
  105. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D6,"|"),6),"|"));
  106. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D7,"|"),6),"|"));
  107. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D8,"|"),6),"|"));
  108. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D9,"|"),6),"|"));
  109. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D10,"|"),6),"|"));
  110. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D11,"|"),6),"|"));
  111. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D12,"|"),6),"|"));
  112. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D13,"|"),6),"|"));
  113. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D14,"|"),6),"|"));
  114. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D15,"|"),6),"|"));
  115. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D16,"|"),6),"|"));
  116. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D17,"|"),6),"|"));
  117. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D18,"|"),6),"|"));
  118. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D19,"|"),6),"|"));
  119. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D20,"|"),6),"|"));
  120. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D21,"|"),6),"|"));
  121. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D22,"|"),6),"|"));
  122. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D23,"|"),6),"|"));
  123. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D24,"|"),6),"|"));
  124. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D25,"|"),6),"|"));
  125. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D26,"|"),6),"|"));
  126.  
  127. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D3,"|"),6),"|"));
  128. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D4,"|"),6),"|"));
  129. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D5,"|"),6),"|"));
  130. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D6,"|"),6),"|"));
  131. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D7,"|"),6),"|"));
  132. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D8,"|"),6),"|"));
  133. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D9,"|"),6),"|"));
  134. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D10,"|"),6),"|"));
  135. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D11,"|"),6),"|"));
  136. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D12,"|"),6),"|"));
  137. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D13,"|"),6),"|"));
  138. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D14,"|"),6),"|"));
  139. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D15,"|"),6),"|"));
  140. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D16,"|"),6),"|"));
  141. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D17,"|"),6),"|"));
  142. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D18,"|"),6),"|"));
  143. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D19,"|"),6),"|"));
  144. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D20,"|"),6),"|"));
  145. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D21,"|"),6),"|"));
  146. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D22,"|"),6),"|"));
  147. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D23,"|"),6),"|"));
  148. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D24,"|"),6),"|"));
  149. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D25,"|"),6),"|"));
  150. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D26,"|"),6),"|"));
  151.  
  152. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D3,"|"),6),"|"));
  153. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D4,"|"),6),"|"));
  154. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D5,"|"),6),"|"));
  155. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D6,"|"),6),"|"));
  156. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D7,"|"),6),"|"));
  157. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D8,"|"),6),"|"));
  158. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D9,"|"),6),"|"));
  159. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D10,"|"),6),"|"));
  160. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D11,"|"),6),"|"));
  161. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D12,"|"),6),"|"));
  162. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D13,"|"),6),"|"));
  163. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D14,"|"),6),"|"));
  164. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D15,"|"),6),"|"));
  165. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D16,"|"),6),"|"));
  166. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D17,"|"),6),"|"));
  167. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D18,"|"),6),"|"));
  168. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D19,"|"),6),"|"));
  169. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D20,"|"),6),"|"));
  170. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D21,"|"),6),"|"));
  171. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D22,"|"),6),"|"));
  172. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D23,"|"),6),"|"));
  173. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D24,"|"),6),"|"));
  174. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D25,"|"),6),"|"));
  175. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D26,"|"),6),"|"));
  176.  
  177. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D3,"|"),6),"|"));
  178. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D4,"|"),6),"|"));
  179. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D5,"|"),6),"|"));
  180. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D6,"|"),6),"|"));
  181. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D7,"|"),6),"|"));
  182. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D8,"|"),6),"|"));
  183. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D9,"|"),6),"|"));
  184. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D10,"|"),6),"|"));
  185. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D11,"|"),6),"|"));
  186. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D12,"|"),6),"|"));
  187. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D13,"|"),6),"|"));
  188. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D14,"|"),6),"|"));
  189. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D15,"|"),6),"|"));
  190. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D16,"|"),6),"|"));
  191. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D17,"|"),6),"|"));
  192. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D18,"|"),6),"|"));
  193. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D19,"|"),6),"|"));
  194. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D20,"|"),6),"|"));
  195. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D21,"|"),6),"|"));
  196. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D22,"|"),6),"|"));
  197. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D23,"|"),6),"|"));
  198. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D24,"|"),6),"|"));
  199. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D25,"|"),6),"|"));
  200. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D26,"|"),6),"|"));
  201.  
  202. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D3,"|"),6),"|"));
  203. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D4,"|"),6),"|"));
  204. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D5,"|"),6),"|"));
  205. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D6,"|"),6),"|"));
  206. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D7,"|"),6),"|"));
  207. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D8,"|"),6),"|"));
  208. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D9,"|"),6),"|"));
  209. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D10,"|"),6),"|"));
  210. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D11,"|"),6),"|"));
  211. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D12,"|"),6),"|"));
  212. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D13,"|"),6),"|"));
  213. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D14,"|"),6),"|"));
  214. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D15,"|"),6),"|"));
  215. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D16,"|"),6),"|"));
  216. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D17,"|"),6),"|"));
  217. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D18,"|"),6),"|"));
  218. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D19,"|"),6),"|"));
  219. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D20,"|"),6),"|"));
  220. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D21,"|"),6),"|"));
  221. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D22,"|"),6),"|"));
  222. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D23,"|"),6),"|"));
  223. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D24,"|"),6),"|"));
  224. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D25,"|"),6),"|"));
  225. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D26,"|"),6),"|"));
  226.  
  227. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D3,"|"),6),"|"));
  228. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D4,"|"),6),"|"));
  229. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D5,"|"),6),"|"));
  230. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D6,"|"),6),"|"));
  231. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D7,"|"),6),"|"));
  232. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D8,"|"),6),"|"));
  233. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D9,"|"),6),"|"));
  234. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D10,"|"),6),"|"));
  235. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D11,"|"),6),"|"));
  236. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D12,"|"),6),"|"));
  237. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D13,"|"),6),"|"));
  238. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D14,"|"),6),"|"));
  239. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D15,"|"),6),"|"));
  240. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D16,"|"),6),"|"));
  241. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D17,"|"),6),"|"));
  242. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D18,"|"),6),"|"));
  243. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D19,"|"),6),"|"));
  244. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D20,"|"),6),"|"));
  245. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D21,"|"),6),"|"));
  246. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D22,"|"),6),"|"));
  247. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D23,"|"),6),"|"));
  248. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D24,"|"),6),"|"));
  249. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D25,"|"),6),"|"));
  250. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D26,"|"),6),"|"));
  251.  
  252. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D3,"|"),6),"|"));
  253. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D4,"|"),6),"|"));
  254. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D5,"|"),6),"|"));
  255. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D6,"|"),6),"|"));
  256. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D7,"|"),6),"|"));
  257. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D8,"|"),6),"|"));
  258. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D9,"|"),6),"|"));
  259. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D10,"|"),6),"|"));
  260. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D11,"|"),6),"|"));
  261. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D12,"|"),6),"|"));
  262. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D13,"|"),6),"|"));
  263. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D14,"|"),6),"|"));
  264. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D15,"|"),6),"|"));
  265. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D16,"|"),6),"|"));
  266. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D17,"|"),6),"|"));
  267. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D18,"|"),6),"|"));
  268. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D19,"|"),6),"|"));
  269. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D20,"|"),6),"|"));
  270. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D21,"|"),6),"|"));
  271. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D22,"|"),6),"|"));
  272. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D23,"|"),6),"|"));
  273. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D24,"|"),6),"|"));
  274. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D25,"|"),6),"|"));
  275. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D26,"|"),6),"|"));
  276.  
  277. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D3,"|"),6),"|"));
  278. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D4,"|"),6),"|"));
  279. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D5,"|"),6),"|"));
  280. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D6,"|"),6),"|"));
  281. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D7,"|"),6),"|"));
  282. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D8,"|"),6),"|"));
  283. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D9,"|"),6),"|"));
  284. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D10,"|"),6),"|"));
  285. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D11,"|"),6),"|"));
  286. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D12,"|"),6),"|"));
  287. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D13,"|"),6),"|"));
  288. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D14,"|"),6),"|"));
  289. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D15,"|"),6),"|"));
  290. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D16,"|"),6),"|"));
  291. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D17,"|"),6),"|"));
  292. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D18,"|"),6),"|"));
  293. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D19,"|"),6),"|"));
  294. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D20,"|"),6),"|"));
  295. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D21,"|"),6),"|"));
  296. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D22,"|"),6),"|"));
  297. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D23,"|"),6),"|"));
  298. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D24,"|"),6),"|"));
  299. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D25,"|"),6),"|"));
  300. TRANSPOSE(SPLIT(REPT(CONCATENATE(Data!D26,"|"),6),"|"))
  301. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!