To organize the data differently than how it is presented in the separate worksheets,but using the same row and column labels so the consolidated worksheet matches the data,use the consolidate by category option.

Question

Quizplus · Accepted Answer

The consolidate by category option allows for the organization of data differently while still using the same row and column labels to match the consolidated worksheet.

To Organize the Data Differently Than How It Is Presented