We show you how to rearrange columns in Excel using four different techniques. Each will ensure that your data will not be overwritten.

Getting to grips with Excel's text functions will be invaluable if you need to split a single column into multiple columns, or create a single column from multiple columns. Peter Hool's Expert guide ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

We use SAPA accounts production which doesn't generate graphs as part of the final reporting. We therefore have to do this via Excel. In 2 or 5 year accounts reports the layout traditionally is for ...