Hello Experts!
Super simple, how can I get every other row into a new field Then delete out the blanks?
In the example below, I woudl like to first delete out any blank rows in the data set (row 2 in the example) and then from there have every other row go into a new field so that the end result is as below as well?
Data:
| This is a |
| |
| So use Alteryx |
| very simple issue |
|
End Result:
| This is a | So use Alteryx |
| very simple issue | to solve it |