How to Convert 2-Dimensional/Cross Table to List in Excel Office 365?
Tags: convert2dimensionalc, kutoolsexceltutorial, kutools
Published: 2020-10-22 12:15:36

---
title: How to Convert 2-Dimensional/Cross Table to List in Excel Office 365?
published: true
date: 2020-10-22 07:25:47 UTC
tags: Convert2DimensionalC,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-convert-2-dimensional-cross-table-to-list-in-excel-office-365/
---

In this post, we will discuss the steps to **Convert 2-Dimensional/Cross Table to List in Excel Office 365** using **Kutools. ** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## **Convert a Cross Table to List:**

To convert a cross table to a list in an Excel spreadsheet, do the following steps.

- You need to **select a cross table** which you want to convert into a list.

![Selection range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Selection-range.png)<figcaption id="caption-attachment-16150">Selection range</figcaption>

- On the **Kutools Tab, select** the **Range** option, then **choose** the **Transpose Table Dimensions** option from the menu.

![Transpose Table Dimensions](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Transpose-Table-Dimensions.png)<figcaption id="caption-attachment-16152">Transpose Table Dimensions</figcaption>

- It will open the **Transpose Table Dimensions Dialog box. **
- In that dialog box, **select** the **Cross table to list** option.
- **Results range – ** In this section, you need to **select any single cell** to display the result using the given browse button.
- **Hit** the **OK** button to get the result.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Click-the-OK-button-2.png)<figcaption id="caption-attachment-16156">Click the OK button</figcaption>

- Finally, you can see that the input table has been converted into a list as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-32.png)<figcaption id="caption-attachment-16159">Result</figcaption>

## **Steps to Convert a List to**  **2-Dimensional Table:**

You can change the list into a two-dimensional table, to do this, follow the below steps.

- You need to **select a list** that you want to convert to a 2-dimensional table.

![Input List](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Input-List.png)<figcaption id="caption-attachment-16160">Input List</figcaption>

- Go to the **Kutools Tab, select** the **Range** option, then **choose** the **Transpose Table Dimensions** option from the menu.

![Transpose Table Dimensions](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Transpose-Table-Dimensions.png)<figcaption id="caption-attachment-16152">Transpose Table Dimensions</figcaption>

- It will open the **Transpose Table Dimensions Dialog box. **
- In that dialog box, **select** the **List to cross table** option.
- Then, you need to **specify a single cell** to display the result using the browse button under the **Results range** section.
- **Click** the **OK** button to see the output.

![Hit the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Hit-the-OK-button.png)<figcaption id="caption-attachment-16161">Hit the OK button</figcaption>

- The below-given screenshot, shown the output two-dimensional table.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-39.png)<figcaption id="caption-attachment-16162">Output</figcaption>

## **Conclusion:**

From this post, we assisted you to understand how to **Convert 2-Dimensional/Cross Table to List in Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Insert Multiple Checkboxes at Once in Excel Office 365!](https://geekexcel.com/insert-multiple-checkboxes-at-once-in-excel-office-365/)
- [Unprotect Multiple Worksheets at Once in Excel Office 365!!](https://geekexcel.com/unprotect-multiple-worksheets-at-once-in-excel-office-365/)