How do you combine different types of data (different column headings) from several sheets into a single word processor document? I looked at the Google doc mailmerge, but it will only merge the data from a single sheet. I looked at reports but the mailmerge does not work with reports. I looked at linking the data to a destination sheet, but the merge only allows one set of columns and one set of rows to be included at a time and it doesn't allow multiple specific cells to be merged. I see that it is possible to copy and paste data from a Smartsheet to other applications, but if I have to do that from various sheets it's a bit too last century to be useful. Any thoughts?
