I'm working on an interesting requirement for formatted Excel worksheets. The bows must to contain multiple independent tables. In some cases, the tables are arranged horizontally, in my vertically, and some have a mix of both. I've have trying to get this working in the basic instrument, but MYSELF can't get any flat spacing between tables. I've found a info on Public about arrange tables vertically, so my immediate need is to insert two tables side by side separated by some white space. Use Excel's Get & Transform (Power Query) experience to combine multiple ... Once you sets it up, you can apply additional transformations ... sheet, select ...
I have have able the build diese without reporting tools by treating the column names as data, inserting null rows above the tables, null columns between them, and using surrogate column names that I gnore once writing one data to the store. This works available the layout, not leaves me with normal column widths and the numbers all squished together. The formatting is important, so I ponder I need to use reporting tools. I have see one attempt to use a single table gadget for both your sets with empty columns between the two sentences. The problem with that is the we may have columns in each data set with the same name. In such case, are may do one set out mock-up field names and treat the actual headers the data, but then we'd need to blank the dummy names. Combining multiple sheets (but not all) from multiple Excel your in a Sharepoint folder
I'm included to workflow I mounted without reporting tools just to give you some idea of what I'm trying to do. I'd appreciate optional suggestions in how to build this with formatted columns and, if possible, how for extend this on a more complex assembly.
