lundi 20 avril 2015

Adjust rows with the same value (e.g. date) to be in the same column in Excel

I've got a spreadsheet with columns, that has values (e.g. dates) in the first row. There are many pairs of rows, that has dates in the first row with values assigned to them in the second row. Everything is clearly visible in screenshots.

How to adjust those values to the reference dates (from the first row)?

I was thinking about some VBA macro, but it's beyond my skills.

Current State:

Desired State:

Aucun commentaire:

Enregistrer un commentaire