How do I show row data in columns on another sheet?


I have a sheet tracking dependencies and dates. For example:

  • Design
  • 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