Rearrange Table Excel: Following a Similar Structure
In this article, we will discuss how to rearrange a table in Excel to follow a similar structure as another table. This can be useful when you have data that needs to be organized in a specific way, but the original table is not set up correctly. We will cover the steps to rearrange the table, as well as some tips and tricks to make the process easier.
Understanding the Original Table
Before we can rearrange the table, it is important to understand the current structure. Let's take a look at an example table:
```vbnet
|----------------|----------------|----------------|
| Goods | Services | Types |
|----------------|----------------|----------------|
| Apples | Cleaning | Fresh |
| Bananas | Repairs | Frozen |
|----------------|----------------|----------------|
```
In this table, we have three columns: Goods, Services, and Types. The rows contain different items, such as Apples and Bananas, and their corresponding types, such as Fresh and Frozen.
Screenshot of the Original Table
Here is a screenshot of the original table:
```diff
+----+------------+------------+------------+
| | A | B | C |
+----+------------+------------+------------+
| 1 | Goods | Services | Types |
| 2 | Apples | Cleaning | Fresh |
| 3 | Bananas | Repairs | Frozen |
+----+------------+------------+------------+
```
Rearranging the Table
Now that we understand the original table, let's discuss how to rearrange it to follow a similar structure as another table. In this example, we will rearrange the table to look like this:
```vbnet
|----------------|----------------|
| Types | Goods |
|----------------|----------------|
| Fresh | Apples |
| Frozen | Bananas |
|----------------|----------------|
```
To rearrange the table, follow these steps:
- Select the entire table by clicking and dragging your mouse over all the cells.
- Copy the table by right-clicking and selecting "Copy" or by pressing Ctrl+C on your keyboard.
- Create a new table with the desired structure by typing in the column headers and rows.
- Paste the copied table into the new table by right-clicking and selecting "Paste" or by pressing Ctrl+V on your keyboard.
- Use the "Sort & Filter" function to rearrange the table. In this example, we will sort the table by the "Types" column.
- Right-click on the "Types" column header and select "Sort A to Z" or "Sort Z to A" depending on your desired sorting order.
- The table should now be rearranged to follow the desired structure.
Screenshot of the Rearranged Table
Here is a screenshot of the rearranged table:
```diff
+----+------------+------------+
| | A | B |
+----+------------+------------+
| 1 | Types | Goods |
| 2 | Fresh | Apples |
| 3 | Frozen | Bananas |
+----+------------+------------+
```
References
This article covered the steps to rearrange a table in Excel to follow a similar structure as another table. By following the steps outlined in this article, you can easily rearrange your tables to fit your needs. Happy Excel-ing!