Data in an Outline Form Needs to be Readable Row by Row

[KmbrlyPC]

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.

[Qiu]

@KmbrlyPC 
I use the tranpose and Cross tab to avoid using multiple Multi-row tools.
For your Excel input, we can use dynamic input to process the multiple sheets with same schema.

I believe there are extra 2 rows a the end of your sample out put file.

[KmbrlyPC]

I am having issues opening the workflow.

[Qiu]

@KmbrlyPC 
Yes, it is a pakage.
Just click Yes when asked. 😁

[KmbrlyPC]

Nevermind, I figured out how to open it!