In Excel, if you want to centralize the same type of data together, there are several ways to do it. Here are some commonly used methods:
With the sorting function, you can group the same category of data together based on a column of data.
Select the column that contains the data you want to sort.
Click on the "Sort" option under the "Data" tab.
Select the columns you want to sort based on, and then select the sort order (ascending or descending).
Filtering can help you hide rows that don't meet certain criteria, so that only the same category of data is displayed.
Select your data range.
Click on the "Filter" button under the "Data" tab.
Click the arrow on the header of the column you want to filter on, and then select the specific category you want to display.
Pivot tables are a powerful tool for summarizing, analyzing, exploring, and presenting data.
Select your data range.
Click on the "Insert" tab and select "Pivot Table".
In the dialog box that pops up, select a new worksheet or an existing worksheet to place the pivot table.
In the PivotTable field list, drag and drop the fields you want as categories to the Rows area, and the data fields you want to summarize into the Values area.
If you want a more complex way of centralizing data, such as based on certain conditions, you may need to use some excel formulas such as if, vlookup, or index and match.
Precautions
Before using the sorting or filtering features, it's a good idea to create a backup of your data.
Make sure that all relevant columns are selected when sorting or filtering so that the rows of the data are not disrupted.
If your data contains a header row, make sure you include that row when using the filter or sort feature.
The above methods can help you centralize the same kind of data in Excel as needed, so as to conduct more effective data analysis and display.