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)
<tbody>
Fruit
Year
Price($)
Apple
2014
1.32
Apple
2016
1.49
Apple
2017
1.55
Pear...