'Google Sheet: break transpose to the next row
Beginning from the date on the right corner of the table, I need to automatically fill the days of the calendar.
Is it possible to transpose until a given cell and break it to the next row?
| 2/2/2022 | |||||
|---|---|---|---|---|---|
| sun | mon | tue | wed | thu | fri |
| 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | ... |
=Arrayformula ( Transpose( AND WHAT?)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|