Pivot/UNPIVOT/CROSS APPLY rows and columns

[Zath]

You're right. I didn't notice you placed the yards with the SUM function. It worked. Thanks.