I'm trying to figure out how to pull unique text from a sheet into one column on another.
We have a spreadsheet with scheduled projects for the month with other project data. Some of this information is duplicated representing multiple days working on one project.
I'm trying to pull unique project names into a column on another spreadsheet to use for reference when being billed. I've attached photos to show how I would like the column to look but automated through a formula.
I suggest you normalize the layout of your data with the following column labels: Date, Project, Team, Slice, Mastic, and Patch. Thereafter, any analysis you would want to make would be easy. With the current layout of your data, worsened by the merged cells, it’s difficult to perform analysis thereon if ever such is even possible.