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.
Personally I don't like this idea because 'merging cells' is essentially a format mask; and you can't merge cells in Alteryx, but you can NULL() or blank the repeated lines, but again to stress, I really don't like the idea of this!
Also I'm not too sure your image has rendered how you'd like, I assume you want the subject and marks still to be aligned in those columns.
Here is an example of how you could do this anyway.
thanks for replying. Yes,my apologies, the output did not get pasted as it was supposed to. Your assumption is right.However, I was able to achieve till this point in my workflow. Now, the challenge is to merge the cells as shown in the attached image. Right now, these cells are using up blank spaces, since it is null. Is there any existing workaround, to merge these cells?
I don't believe it can be done, when importing a merged cell into alteryx the text is effectively stored in the first row and the second will simply be null(). If you leave the cell as null the visibility will be just as good for your stakeholders, it would just take a little re-adjustment to see it that way.