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.

Fields

  • 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

transpose-example-1

After - Number of columns = 3

transpose-example-2