Question: I have a div that has a background-image with the background-attachment as fixed. I change from fixed to scroll when the div with the background images is halfway using jQuery. I seem to have got it working however when I scroll down, there seems to be jump when the property is changed. How can I avoid this jump?

```js
$(window).scroll(function() {
  var halfHeight = $(window).height() / 2
  if ($(this).scrollTop() >= $('.service-logo').offset().top + halfHeight) {
    $('.service-logo').addClass('bg-scroll');
  } else {
    $('.service-logo').removeClass('bg-scroll');
  }
});
```

```css
.content {
  background: red;
  height: 1000px;
}

.content2 {
  background: black;
  height: 1000px;
}

.service-logo {
  background-image: url(https://www.w3schools.com/css/img_5terre.jpg);
  background-attachment: fixed;
  background-repeat: no-repeat;
  background-size: 200px;
  background-position: center;
}

.bg-scroll {
  background-attachment: scroll !important;
}

.content3 {
  background: green;
  height: 1000px;
}
```

```html
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.2.3/jquery.min.js"></script>
<div class="content">

</div>

<div class="content2 service-logo">

</div>

<div class="content3">

</div>
```

Answer: 
Use `SPLIT()` with corresponding delimiters in an array and apply a `TRANSPOSE()` so instead of consequent cells horizontally, it will return emails in rows.

```
=TRANSPOSE(SPLIT(A1, {"|" ; char(10) ; ";" ; ","}))

```

Add any email-separating character you want inside the curly braces above. `char(10)` is the *line break* character.

If you want to apply the formula to a whole column or an array of cells, put the formula inside an `ARRAYFORMULA()` and change the cell address to an array:

```
=ARRAYFORMULA(TRANSPOSE(SPLIT(A1:A, {"|" ; char(10) ; ";" ; ","})))

```

Toggle with `TRANSPOSE()` and see which one returns your desired results.
In the code you provided you are doing this `var cell = e.toString().split("\n");` if you want to split by "\n" and ";" you can chain split and joins.

This is some code that illustrates what I mean:

```
var x = "a\nb\nc";
var y = "a;b;c";
var z = x+";"+y;

console.log(x,x.split('\n').join(';').split(';'));
console.log(y,y.split('\n').join(';').split(';'));
console.log(z,z.split('\n').join(';').split(';'));

```