Transposing Data with INDEX
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 Sales Value and the data itself including the transactional data namely …