How do I show row data in columns on another sheet?
I have a sheet tracking dependencies and dates. For example:
- Implement (dependent on design)
- Test (dependent on Implement)
I want to show these 3 key dates on a dashboard or other sheet with the columns:
- Project feature | Design date | Implement Date| Test Date | Status
Is this possible?
Cell linking does not work since it only copies from 3 rows to 3 rows on another sheet, or 3 colums to 3 columns
Report view did not put the dates underneath the column headings for Design | Implement | Test