On Sheet1 is exported data and this data continues on for ~2,000 rows (dates in "Column A" and data in "Column E" under category D). Goal is to copy the dates in "Column A" along with the data in "Column E" category D only and paste it in "Sheet2" as shown in the attached workbook.
test.jpg
test1.jpg
Bookmarks