How to flatten a table in Excel

In most times of collecting and writing data tasks, you will use a spreadsheet software like Microsoft Excel. And you end up with a two dimensions table where each key has a dedicated column.

Of course, it is a simple table, easy to be read by humans. But if you want to transform it to a dataset or a list of keys/values, to be imported into a database system, then you must convert your 2D table to a flat table.

This tutorial will show you how to flatten a table in Excel, using VBA script :

Continue reading “How to flatten a table in Excel”