loading...

How to Convert 2-Dimensional/Cross Table to List in Excel Office 365?

excelgeek profile image Andrews Originally published at geekexcel.com on ・3 min read

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

Note: kutools for Excel 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
Selection range

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

Transpose Table Dimensions
Transpose Table Dimensions

  • 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
Click the OK button

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

Result
Result

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
Input List

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

Transpose Table Dimensions
Transpose Table Dimensions

  • 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
Hit the OK button

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

Output
Output

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. Keep Learning!

Read Also:

Discussion

pic
Editor guide