![how to consolidate data in excel for mac how to consolidate data in excel for mac](https://midatlanticconsulting.com/blog/wp-content/uploads/2018/10/Numbers-Merge-Cells-from-Context-Menu.jpg)
That parameter is the number of rows in the table you need reordered. To tell it to use all the rows, we use SEQUENCE() with one parameter (since "rows" or output is its first parameter, we need no more). INDEX() is given the table you wish reordered, I1:O4 in this case. (For the formula, I put a 6 column by 4 row table in A:G, then another in I:O with the same headings but they are of mixed order relative to the A:G table.) To reorder the columns without any amount of work to speak of, simply use the following formula: =INDEX($I$1:$O$4,SEQUENCE(ROWS($I$1:$O$4)),MATCH($A$1:$G$1,$I$1:$O$1,0)) If changing them is fine, that's easier, a wee bit since there is no copying of the files, but if the files will continue to be used, and simply reordering the columns will cause no problems, it would be very much nicer to change them so that they never need changed again in the future. If they must stay as is, make a subdirectory and copy all of them to it. I did not see whether the files that you use must continue their existence exactly like they are now or if they can be modified.
![how to consolidate data in excel for mac how to consolidate data in excel for mac](https://www.wallstreetmojo.com/wp-content/uploads/2019/01/Consolidate-Example-1-1.png)
However, if the files are not beastly in size so that a VERY simple formula approach could do the work without choking your computer to a halt, or Excel at least, then the following is a very simple approach indeed. It can definitely do the job, this much I know, though I do not think I'd get it done soon.
![how to consolidate data in excel for mac how to consolidate data in excel for mac](https://i1.wp.com/datacycleanalytics.com/wp-content/uploads/2016/10/6_CbP.png)
It can do some amazing things (amazing to one used to being limited by Excel's limits, and not widely enough experienced at VBA to do more than marginally complicated things).
#How to consolidate data in excel for mac how to
So I will not talk about how to achieve it here, at least not today. I do not personally currently have the skills with it to reorder your columns in a particular order, though I could reorder them alphabetically. If your files are beastly in size, look into Power Query.