I have a sheet with rows which contain mostly foreign key references to the first column (primary key) in other sheets. The relationship is one to one. I wanted to make a pivot where one of the columns in the first sheet was the first row, and each foreign key column was nested under it, but expanded to reveal the row data from that sheet.

Maybe a pivot is not the optimal way to do this?

This is primarily for review by other people and I was hoping to make it helpful, does such a technique exist?

Thank you.