I have requirements where I'm supposed to take an Excel input and split the data into a dynamic number of multiple Excel outputs depending on input for another source. The difficulty is that each record takes up two rows of the sheet, the first row might be blank, and the output needs to be in the exact same format as the input.
You need to explain this better I am afraid. The first part suggests that you are multiplying rows, the second seems to suggest that the input needs to match the output. Can you explain this with examples, that might help
I apologize for the confusion - the problem would be more obvious if I could show you the actual data.
Based on my abbreviated example, here's the general format of the data
Record 1, Row 1: 1, John Smith, London
Record 1, Row 2: 1, John Smith, London
Record 2, Row 1: blank
Record 2, Row 2: 2, Jane Smith, Paris
Each record always has two rows. The first row of each record may or may not have data. The second row of each record always has data. The expected output must retain the same structure of two rows per record, with the rows in the same order as the input.
The task is to take the input, filter based on user input passed through context variables at run time, and output the designated subset of records in the same format as the input.
I hope this clarifies my requirements. Any advice would be greatly appreciated.
