When you need to apply a small tweak to the document, it should not take long to Rearrange spreadsheet deed. This sort of basic action does not have to require extra training or running through manuals to understand it. With the right document editing instrument, you will not spend more time than is needed for such a swift change. Use DocHub to simplify your editing process whether you are an experienced user or if it’s your first time making use of a web-based editor service. This instrument will require minutes to learn how to Rearrange spreadsheet deed. The sole thing needed to get more productive with editing is actually a DocHub account.
A simple document editor like DocHub will help you optimize the time you need to devote to document editing no matter your prior knowledge of such tools. Create an account now and enhance your efficiency immediately with DocHub!
okay so first of all i have brought this data into excel from another file and you can see it hasnt quite been transferred across properly each line is split across three rows if i take the headings here and click and drag them they should be lined up like this however i cant just click and drag every single row because there are too many of them if i go down to the end of the table youll see i have over 2 000 rows so i need to find some other way of doing this first of all im going to do equals and then select this cell here and enter then i can drag this across to get all of the numbers in the top row and then i will do equals and move on to the next row and click and drag this across as well and then finally i can link to this cell here then ill move on to the next line and link to this cell here and drag this across and then link to this cell and drag that across as well and finally link to this cell now i will select these two lines and press ctrl h to open up the find and r