I am trying to create a weekly summary report using data from multiple CSV's. Currently I have each CSV writing to multiple sheets within an xlsx file, but ideally I would like to write all of the CSV's in succession in one sheet. The issue is that the CSV's do not have the same name or number of columns and when they all write to one sheet with FeatureWriter it creates duplicate columns and blank cells.
On the attached xlsx, Sheet1 shows how I would like the final sheet formatted and Sheet2 is how the writer is currently combining the CSVs.
Thank you in advance!