Pivoting reports into tables

A very long time ago my mentor at the time took a peek at a spreadsheet full of data I was tasked to read into QlikView. "That data is in a reporting format.", he said hinting at the fact that there was one column for each year of metrics. "You will ...