Pivot in Alteryx

[8802036946]

I am attaching dummy input and expected output. Please help.
Row to column and columns to row

I have 2000 files like this and have to be merged together to know how the access has changed for each user as per the date. 

[OllieClarke]

Hey @8802036946 

Here's a workflow which does this...

If all the files are in the same folder, and have the same schema then you can use a wildcard input (https://www.thedataschool.co.uk/borja-leiva/4840/) to read in all the files at once.

I also tick the 1st row contains data, and output the filename to allow for pivoting each file independently.

Hope that helps,

Ollie