Position If you''re planning to combine data that''s in the same cell in each of several ranges, you can consolidate by position.
Category If you have several ranges with different layouts, and you''re planning to combine data from rows or columns that have matching labels, you can consolidate by category.
Consolidate by position or category