Back to All Articles

ERP Reports Where Data is in Rows instead of Columns: Transposing Reports From Your ERP System

b2winsuite
b2winsuite
B2Win Suite Team
May 14, 2020 3 min read
Data in Rows instead of Columns transformation - Illustration

There is a known limitation in Infor LN and Baan when it comes to reports with a large number of columns. As a result, the ERP system provides canned reports with data spread in rows instead of columns, with one value per line and not the familiar tabular format.

Data in Rows instead of Columns - Illustration

Transposing rows to columns

B2Win Suite allows you to convert such reports into a structured Excel sheet. See how you can create a design template and automate the process:

Turn row-based ERP output into clean tabular Excel sheets.

About the author
b2winsuite

b2winsuite

B2Win Suite Team

Posts authored by the B2Win Suite team.

CategorySolutionsTagsInfor LNBaanExcelTranspose
B2Win Suite logo

The Platform for Data

& Document Automation

Discover B2Win Suite

Discover how B2Win Suite brings replication, reporting, document output, and ETL together in one unified workflow platform — built for modern IT teams, with Infor CloudSuite environments (LN, M3, SyteLine, and more) in mind.