Alteryx Reporting Merging Cells

jaimonsk

Hello experts,

I've been trying to create an automated  word report for an analysis. Here I encountered a situation similar to this.I would like to merge cells from 3-7 and map it as shown the expected output screenshot

What i currently have

Expected Output

Thanks in advance

danilang

Hi @jaimonsk 

@TrevorS has a good solution but it deals more with merged columns.  Your requirement is for merged rows.  You can do this without using  the reporting tools.

The first Multi-Row tool builds up the merged text by adding a newline character ASC(10) between the current text and the text form the line above, based on the "Not Mapped" value in field 2.  The second one adds a new boolean field that determines if we want to keep this row in the output.  The T output of the filter only passes rows where "KeepRow" = true.  The final output in Excel looks like this

The newlines will carry over through the reporting tools to the word document as well.

Dan

MergeVertical.yxmd