Create a file and enter data in columns

Hello!!!!!!!!
I have an issue regarding inserting records in a file columnwise.Is it possible using awk/nawk script?

Example:
File1:
1|AAA|25|2
5|qqe|20|7
4|wer|31|81

I need to create a second file in which data can be inserted in a columnwise manner i.e.
File2:
AAA|25|1|2
qqe|20|5|7
wer|31|4|81

The columns are mapped using map file and is dyanamic.
Please suggest

Please don't double post - it's against the rules.
Thread closed.