Selecting only few fields 3 ( Has subject ID, Stimulus defines and %Change) rows out of 1500 ..(.Problem is they appear in different cell location for every excel file) is from the Excel file, copy and save them in Master Excel file.
In my head it works perfectly:
1) drag .dat file into Excel to open
2) Get data from selected variable from Excel file ( has variable name but cell location is keeps changing)
3) Copy from Excel sheet into Master Excel sheet ( If possible transpose or paste in table format)
4) Next open second .dat file from the folder, repeat steps 2 and 3...make sure append the pasted data in next line in Master sheet.
5) repeat step 4 for 120 times
In my head it works perfectly:
1) drag .dat file into Excel to open
2) Get data from selected variable from Excel file ( has variable name but cell location is keeps changing)
3) Copy from Excel sheet into Master Excel sheet ( If possible transpose or paste in table format)
4) Next open second .dat file from the folder, repeat steps 2 and 3...make sure append the pasted data in next line in Master sheet.
5) repeat step 4 for 120 times