How to Make One Row Appear After Another in a Table

Introduction

This article describes how to go from a standard table...

...to a table where a specified row has been moved automatically. In this example, Diet Pepsi has moved after Pepsi Max:

Requirements

A table with rows. Tables with row spans are not compatible with this rule.

Method

1. Select your table.

2. In the toolbar go to Automate > Browse Online Library > Sort/Reorder Rows or Columns > Make One Row Appear After Another.

3. Using the drop-downs, select the row you want to move and the row you want it to appear after.

4. Press OK.

Note, if you select Switch rows and columns on your table, the rule will no longer work due to the table dimensions changing. In this case, you will have to apply the Make One Column Appear After Another rule instead.

Additionally, rows moved using this rule cannot later be moved manually via drag and drop.

Next

How to Use Rules in Q

Adding Rules to Project Templates

Caveats and Limitations for Rules

Rules, QScript Macros and When To Use Them