Hi,

I have a spreadsheet with 10 columns, each column with various criteria such as Date, Day, Time, Content Pillar, Platform, Status, Approval Date etc. The data in the Content Pillar column is based on a drop down with four options, all other columns have static (manually entered) information. I am trying to populate this data onto different sheets representing each Content Pillar. For example, if one of the Content Pillar cells has "Entertainment" then I want that whole line of data to populate on the first row of the Entertainment sheet. If the next line has Education, then I want all of that data to populate onto the first row of the Education sheet. Then if the third line of data has Entertainment again, I want this whole row of data needs to get populated to row 2 of the Entertainment sheet. I do not want a blank row 2 and the data populating on row 3.

I have tried using VLOOKUP, but it only will select the first instance of each Content Pillar and repeat that in each row.

Hope this makes sense - feel free to ask any questions. I would provide the spreadsheet, but it contains a lot of confidential information.

Thanks!