How to link Excel Vertical to Horizontal Cells or vice versa

A trick learn today when come across this scenario where I need to link 2 sheets together.

Advertisements