Thomson ONE Banker Transposer User Manual

This is an article about how to use the Thomson ONE Banker transposer tool, which can turn the default data output of Thomson ONE Banker into output per variable, making it easier to use the data in SPSS and other software.


Thomson ONE Banker Transposer User Manual - cover page
Brand
THOMSON
Category
Other
Document type
User Manual
Language
English
Pages
3
File format
PDF
File size
879 KB
Published
21 October, 2023
Updated
21 October, 2023
MD5 checksum
8BA831AA040F9937A80063D873B9E252

About this manual

This manual explains how to use the Thomson ONE Banker Transposer, a tool that converts default report output into variable-based output for easier use in software like SPSS. The process involves opening the transposer, pasting data from the Report Wizard, running a macro, and waiting for the transposed output to appear.

The tool requires the output to include 'Entity Name:' in the upper left corner to function correctly. Users must enable content in Excel to run the macro, and the output is generated in a new 'Transposed' sheet.

What's inside

  • Opening the Thomson ONE Banker Transposer
  • Preparing Data from Report Wizard
  • Running the Transpose Macro
  • Viewing Transposed Output

Frequently asked questions

How do I run the Thomson ONE Banker Transposer macro?

In Excel 2007, go to the View tab, click Macros, select TOBtransposer_AvO.xls!Transpose.Transpose, and click Run.

What is required for the Transposer to work correctly?

The output must include 'Entity Name:' in the upper left corner; otherwise, the macro cannot start transposing.

Download PDF (879 KB)

More THOMSON Manuals


View all THOMSON manuals →