Hello. I have a an excel spreadsheet with each tab having monthly data relating to product performance. The products are across the columns and metrics are along the rows. The formats are the same for each tab (with maybe some exceptions of additional products added in the columns).
Is there a way that I can format this data easily so that I can use pivot tables and charts?
Bookmarks