Data consolidation from Multiple CSV files and then Split data into number of files

Hi All,

I am stuck with a unique problem and would really appreciate some help here.

I am consolidating data from Multiple CSV files into one, i have used a VBA macro to do that, my problem is that once data is consolidated into single CSV files i want to transpose set of data from Rows to Column, and then insert plank column after every 5th row, apply true or false formula in row 5 to check that anything is mis match in row 2 and row 4, then based on mismatch values create seprate sheets so that they can be distributed.

Please help, set of 4 rows with each row has 1681 column entries which should transpose and then apply required formula.