How to export all the data in the schedule after filling it out and putting the data in another sheet, such as the name of the employee with its dates from the beginning of the month to the end of the month and exporting it on a page, like this page you made https://docs.google.com/spreadsheets/d/1hhEs01waUxXkkVT1ZjvTpzGZ4IBpOjIYstQN4pu2QWY/edit?usp=sharing schedule all data
1 Answers
use:
=ARRAYFORMULA(TRANSPOSE({TEXT(Sheet1!C8:8, "dd-mm-yyyy");
FILTER(Sheet1!C8:800, Sheet1!B8:B800=A2)}))
Related