Transpose CrossTab (cross table) to List

DigDB

Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download ^{free 15-day trial} | Purchase | FAQ | Contact

Transpose CrossTab (cross table) to List (flat table)

CrossTab (cross table) is a two-dimensional table with a horizontal header row and a vertical header row. We sometimes need to transpose it into a one-dimensional flat list table. Note that this is different from Excel's Copy and 'Paste Special...' with the 'transpose' option. Excel's Pasting with transpose do NOT convert a cross table into a list.

Click a single cell in your table area. Invoke 'DigDB->Table->CrossTab to List...'. The table area will be automatically selected.

Practice file - transpose-cross-table-demo.xls (16k)
Click 'OK' to start the transpose
Result table after transpose:

If there are more than two dimensions, for example, pivot table report sometimes has more dimensions, then the transpose will not work. Transpose can only work on the simple two dimension cross tables.

Some users asked for a reverse transpose, i.e., to transpose a list into a cross table. This is currently on our development list. We don't have this function yet.

Need more?

Browse the complete list of DigDB's powerful features listed on the front page.
If you see errors or things not working, check out our error reference page.

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.