Select * from
(select Row as Поставщик_Row , Fact as Поставщик_Fact, Type as Поставщик_Type
from Stake where Range = 'Sheet1' AND Type = 'Поставщик') [myПоставщик]
LEFT JOIN
(select Row as Количество_Row , Fact as Количество_Fact, Type as Количество_Type
from Stake where Range = 'Sheet1' AND Type = 'Количество') [myКоличество]
on [myПоставщик].Поставщик_Row = [myКоличество].Количество_Row

Left Join
(select Row as Товар_Row , Fact as Товар_Fact, Type as Товар_Type
from Stake where Range = 'Sheet1' AND Type = 'Товар') [myТовар]
on [myПоставщик].Поставщик_Row = [myТовар].Товар_Row

Left Join
(select Row as Клиент_Row , Fact as Клиент_Fact, Type as Клиент_Type
from Stake where Range = 'Sheet1' AND Type = 'Клиент') [myКлиент]
on [myПоставщик].Поставщик_Row = [myКлиент].Клиент_Row

Left Join
(select Row as Адрес_Row , Fact as Адрес_Fact, Type as Адрес_Type
from Stake where Range = 'Sheet1' AND Type = 'Адрес') [myАдрес]
on [myПоставщик].Поставщик_Row = [myАдрес].Адрес_Row