In fact in Tableau, the pivot menu does an unpivot action.
You words, sample excel files are not matching.
If you data is in table format, yes we can show the data in Pivot Table. By keeping Entity on Column shelf, Factor on Row shelf.
If you data is in Pivot, Then Keep Entity on Column shelf, F1, F2, F3 on the Text shelf ( Marks Shelf)
Then in the Show me, selct the "Text Table", it will keep Entity on Column shelf, Measure Names on the Column shelf.
Then You can change the Measure Names to Row Shelf.