Transpose Column to Rows
The Transpose Columns to Rows feature will take a vertical column (or columns) of entries on the worksheet and transpose it into a series of horizontal rows. This tool is intended as a pre-processor for the Flowchart Wizard, to allow you to easily layout out the entries for a left to right flowchart before running the wizard.
- Number of columns: This field determines how many entries will be placed in each horizontal row. The two pictures below show the process steps before and after transposing columns.
- Output Location: Option to preserve original content or overwrite it with transposed content.
Before Transpose Columns to Rows
After - Number of columns = 3