Consolidated list of texts

Copper Contributor

I have 5 worksheets where people have 4 columns where they can enter text.

I want to create a separate worksheet where all the unique items that have been listed anywhere in their worksheets will all appear in one column.

2 Replies
Is there a way to attach a file?


If you don't see an area below the box where you compose a reply with text "Drag and drop here or browse files to attach", you can upload a file to a cloud service such as OneDrive, Google Drive or Dropbox, obtain a share link to the uploaded file and paste that link into your reply.