excel-data-preparation

A VBA algorithm that organizes exported data from a third-party software into an organized Excel table.

Introduction

Some third-party software export their data in a unorganized Excel sheet, preventing it to be properly analyzed. The most common problems are: blank rows, blank columns, numbers formatted as text and so on. Instead of manually organizing this data, this repository contains a VBA algorithm that automatically organizes it into an Excel table that is more suitable for data manipulation.

Usage

Open Microsoft Excel and follow these steps:

1. Press Alt + F11 to access the VBA editor;
2. In the VBA Editor, create a new Module and paste all the code from the data_preparation.bas file inside that module;
3. In Excel, activate the sheet you want to organize;
4. In the VBA Editor, click on the "main" Sub and run the code pressing F5 or going to Execute -> Run.