Welcome, Guest. Sign In | Register
Click here to go back to the main website. Start a Live Help session.

Knowledge Base » SigmaXL Toolbox

Preparing Data for Analysis

on January 01, 2012

How can I prepare my data for analysis by SigmaXL?

Preparing Data for Analysis in SigmaXL

SigmaXL requires data tables to be in a specific format.  All columns must have one column heading and each of these headings must be unique.  There can be no empty rows or columns.

To delete empty rows or columns:

1. Click SigmaXL > Data Manipulation  >  Data Preparation > Delete Empty Rows and Columns.

2. Check Delete Empty Rows and/or Delete Empty Columns.

(Note, this action CANNOT be undone - copy the data set to a new sheet before formatting if the current format must be kept).

Was this helpful? Yes No Print/Save Pdf