Search code examples
google-sheetsfilterformattingstring-formattingtranspose

How to Export all data in schedule after filled put another Sheet

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

Solution

  • use:

    =ARRAYFORMULA(TRANSPOSE({TEXT(Sheet1!C8:8, "dd-mm-yyyy"); 
 FILTER(Sheet1!C8:800, Sheet1!B8:B800=A2)}))

    enter image description here