VBA macro Code for grouping based on column A

[Dharani Suresh]

Hello everyone,
i need to group the values based on A, B, C columns.

which means all "Chickpea_B-1_11area_3d.csv " will have same timestamp and mean_area_3d values, only D column vlaue changes.....
in the same way, all "Chickpea_B-1_12area_3d.csv" will have same timestamp and mean_area_3d values, only D column vlaue changes.....

now i need all Chickpea_B-1_11area_3d.csv values to be grouped into one. and chickpea_B-1_12area_3d.csv values to be grouped into one..

if you see the output sheet, you will understand clearly, which i did manually for your easy understanding...

i did manually and also attached the sheet for your kind reference and easy understanding... where i grouped all Chickpea_B-1_11_area_3d aver_domain_area, fill_factor, leaf_angle_theta, plantHeight, projected_leaf_a into one.... where b and c cols are same for all the D E F G H I Values. in the same way for Chickpea_B-1_12_area_3d and all other below values to be grouped.

like this i have to do for 1000 files. please help me..
please find the attachment...

Thank You...

With Kind Regards,
Dharani.