Transpose column in multiple steps...

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Format › 5. Transpose column in multiple steps...

Transposes data from one column to several columns in steps.
Useful when you have to deal with a large amount of data in one column and have to transpose every X rows.

Formulas and formatting will be preserved.

Screenshots

Example screenshot: Transpose column in multiple steps

Practical tricks on how this can help you

Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

Tip: Easily transpose 1 column into multiple rows, creating a table

Starting this tool

Click ASAP Utilities › Format › 5. Transpose column in multiple steps...
Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...

Format › 5 Transpose column in multiple steps...

Additional keywords for this tool:
advanced transposer

Detect and visualize adjacent data/group changes...

The paper saver (split columns)...

Download

©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

Empowering Excel Users Worldwide for 25 Years