Manipulate Excel Spreadsheet Content

1 )We have a spreadsheet containing data on multiple worksheets, the data needs to be filtered and combined onto one worksheet with all duplicates removed

2) We have a spreadsheet with one worksheet, there are multiple values in one of the columns in each row separated by a comma, these values need to be separated and inserted into new unique rows.