Excel VBA transfer two dimensional array to one dimension
<p>I'm not mathemathics, but I need to solve some mapping function in VBA.
I have string array Divisions, which is filled by checked checkboxes on form (array is filled by string or zero, like on picture). I need to found some function which converts my array (on left, always 3x4 dimension) to array on right (nx1 dimension). Here are examples: 
<a href="https://i.stack.imgur.com/l2vs0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/l2vs0.png" alt="enter image description here"></a>
 Do you have any ideas? Does it exists some kind of map function in VBA, which can do, what I wish? Thank you</p>