Transposing Data with INDEX / MATCH combo
Transposing Data with INDEX / MATCH combo what’s this all about? OK imagine this – you have done the right thing as a budding data analyst and created your sales data down the page so that you can take advantage of Pivot Tables which likes dimensions of data going across in columns namely Date and …