Excel columns

Hi Steve

Thank you for sending your file over.

I took a look at your request and consulted other colleagues, unfortunately we think it's very difficult to achieve what you outlined.

You currently have your data set out in the optimal way for working in Excel - listed in columns. Rearranging the data to sit in horizontally along one line will take a long time and will actually limit the analytical capability of your data.

I suggest using the multi-level sort tool (found in the Data Ribbon) to organise the data by product and best before date, or using the filter tools. You may also like to use conditional formatting to highlight products nearing best before. Creating a Pivot Table is unlikely to help you achieve what you want, as PT's condense and summarise your data, allowing you to analyse and create reports rather than rearrange data.

Sorry to not be able to help further, but do let us know if you have any other questions in the future.

Kind Regards,
Sarah
Excel Trainer