My advice:INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

After Running the below Select Statement what you given for example my records are like below,

SELECT Name, MIN(case when Unit = 'tt' then ISNULL(Figure,0) end) as tt, MIN(case when Unit = 'm' then ISNULL(Figure,0) end) as m, MIN(case when Unit = 'ft' then ISNULL(Figure,0) end) as ftFROM TBL_SAMPLE group by name