Hello, I am using monarch to read several daily reports, and compile all these reports into a balancing excel sheet daily. Each report produces its own table, all of these tables vary in rows and columns. Some of the tables are consistent with rows and columns daily, but there are a couple that have a different amount of rows every day. However when it does vary it is very small, one line longer or shorter.
Right now, I am copy pasting each table separately into an excel sheet that reads each table and puts them into their proper positions. When there is a variance in the amount of lines, I usually end up leaving a space blank for where the item that is missing belong. (see table).
What Monarch produces
What I input to the spreadsheet
This process has brought two questions.
1. Can monarch keep the section c even if it cant find where c would usually be? Sometimes the reports do not have a section c but I would like to be able to copy and paste a consistent size table.
2. If I am able to make the size of the table consistent, what would be the optimal way of making all these tables 1 item that I can copy paste into an excel sheet that reads it?