I have an excel file that has 400 rows of data. I need to copy every 2 rows of data into a pipe delimited text file. I also need to copy row 1 into every file. So, every file with have the first row from the excel file and the next two rows of data. There will be 200 files.

One more note: there is only data through column X, but need the pipes to go through columns AB

Location: c:\user\

Filenames: Loader1.txt, Loader2.txt, etc.