Forum Discussion
Blank Cells Item
IMHO, some additional logic is to be defined. For example, in first table you have records with no values for item and price. In second table there are few records for such category. Not clear which to take - first one, or one with highest price or what.
Same if we have only category and price, but in second table there are few records for that category with the same price. Which one do you select if do that manually?
IMHO, some additional logic is to be defined. For example, in first table you have records with no values for item and price. In second table there are few records for such category. Not clear which to take - first one, or one with highest price or what.
Same if we have only category and price, but in second table there are few records for that category with the same price. Which one do you select if do that manually?
Thank you! I was able to clean it before checking this thread and this is exactly what I did. Appreciate it.