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'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
@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.