When importing data into Prism, can I rearrange it at the same time?

You can filter or transpose data "on the fly", either from another program or from elsewhere in a Prism project, by using the "Import" or "Paste Special" command. When the "Format Data Object" dialog opens, choose the "Filter" or the "Placement" tab to specify how the data should be rearranged.