This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am unaware of any native way of pulling that value in all cells, but I looked at what Alteryx was doing when pulling those merged cells. It seems that the first cell is populated and the rest show as null.
I have put in an example where we use the multirow tool in order to fill the nulls in with the values above using this formula.