Hi,
The best way is to use Get & Transform (aka Power Query) to do that as follows:

Please find the attached file to see the solution.
Try to change the Qty number, then go to:
Fruits Table >> Right-click >> Refresh
and see how it's updated.
Hope that helps
@FarukAhmed