Help with Grouping and zipping folders

Meta Post Here to Contact Site Administrators and Mods
1 
  
 Hi can you please help with the below ?
  
 source file:
 Column1,Column2,Column3,Column4
abc,123,dir1/FXX/F19,1
abc,123,dir1/FXX/F20,1
abc,123,dir1/FXX/F23,2
abc,123,dir1/FXX/C25,2
abc,123,dir1/FXX/X25,2
abc,123,dir1/FXX/A23,3
abc,123,dir1/FXX/Z25,3
abc,123,dir1/FXX/Y25,4
 I want to move the folders (F19,F20,F23 etc. from Column 3 which is the folder path ) according to their respective grouping name in Column 4 (1,2,3,4 etc) such that folders marked under the same group move to another folder which will have the same name as that of their 
group name and this folder should then get zipped.
 
for eg: 
 folders F19,F20 should move to another folder "1" (group name) and then zipped as 1.zip
folders F23,C25,X25 should move to another folder "2" (group name) and then zipped as 2.zip
folders A23,Z25,Y25 should move to another folder "3" (group name) and then zipped as 2.zip
2

This is the forum to contact administrators for site problems.

Please post your question elsewhere.