I have 100+ spreadsheets with the same 6 fields that need to be cleaned up so the data reads line by line (row by row). Here is an example of what the data inputs look like in terms of structure and the output that I am needing. I also attached an excel spreadsheet to show this example. I was planning on using the union tool to join all spreadsheets into 1, but then I am not sure how to clean it up to get to the Output I need.
