I am new to creating Macros and would like to know if there is a way to write a macro to do the following.
I would type information into two columns in Excel as follows:
I would then run a macro to change these two columns to create a column like this:
Is this possible by using a macro? Thank you.
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