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.
Bookmarks