Transform data format from wide format to long format

The two most common data structures in use are wide format data tables and long format data tables. The wide to long data format allows you to transform data into long format in order to use your data in other applications.

Step 1: Select the data from the left file tree or from “files” tab which needs to be manipulated.

Step 2: Once you select the file, the file will be opened in the “Data Wrangler”.

Step 3: Click on the “Wide to long format” and a popup will appear.

Step 4: The wide to long data format creates a single column for all the value columns selected and a second column for the descriptors of those parameters.

Step 5: The default “Result” is to overwrite the original file with the updated file.

Select what you want to save as your output file from the “output” dropdown menu.

If you want to keep the original file along with your updated file then, click on “Keep all columns” or “only keep selected columns” under “create new file”. Click “run”. The new file will be saved in the same folder as original file.