combination vlookup & hlookup

[Kevinlzh]

Guys, I need urgent help with converting of the below raw data into the below format of data to be presented. I am open to all other methods, not necessarily using vlookup/hlookup.

Thank you.

(Raw data)
[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD]Fruit[/TD]
[TD]Year[/TD]
[TD]Price($)[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]2014[/TD]
[TD]1.32[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]2016[/TD]
[TD]1.49[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]2017[/TD]
[TD]1.55[/TD]
[/TR]
[TR]
[TD]Pear[/TD]
[TD]2013[/TD]
[TD]1.48[/TD]
[/TR]
[TR]
[TD]Pear[/TD]
[TD]2015[/TD]
[TD]1.60[/TD]
[/TR]
[TR]
[TD]Pear[/TD]
[TD]2017[/TD]
[TD]1.29[/TD]
[/TR]
</tbody>[/TABLE]


(Format to be presented)
[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]2013[/TD]
[TD]2014[/TD]
[TD]2015[/TD]
[TD]2016[/TD]
[TD]2017[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]na[/TD]
[TD]$1.32[/TD]
[TD]na[/TD]
[TD]$1.49[/TD]
[TD]$1.55[/TD]
[/TR]
[TR]
[TD]Pear[/TD]
[TD]$1.48[/TD]
[TD]na[/TD]
[TD]$1.60[/TD]
[TD]na[/TD]
[TD]$1.29[/TD]
[/TR]
</tbody>[/TABLE]

 

[njimack]

Assuming your raw data is in cells A1:C7 and your 2nd table is in A9:F11, enter the below (confirm with ctrl+shift+enter)
=INDEX($C$2:$C$7,MATCH($A10&B$9,$A$2:$A$7&$B$2:$B$7,0))

 

[Kevinlzh]

Assuming your raw data is in cells A1:C7 and your 2nd table is in A9:F11, enter the below (confirm with ctrl+shift+enter)
=INDEX($C$2:$C$7,MATCH($A10&B$9,$A$2:$A$7&$B$2:$B$7,0))

Wow you are a lifesaver! Thank you so so much!