I have 2 spreadsheets, in the first spreadsheet, in column E, if there is any value present ( whether numeric or text then show its corresponding cells ( i.e only name and ID) in another spreadsheet.
Sheet 1:
Desired Output in spreadsheet 2:
Thank you
For the ideal output, you may try:
=filter({'Sheet 1'!D:D,'Sheet 1'!A:A ,'Sheet 1'!E:E},'Sheet 1'!E:E<>"")