|
|
#3
04-18-2021, 04:18 AM
|
||||
|
||||
More seriously, I would have suggested Power Query but you need Office 365 for the Mac for that, so the next stage is likely, unfortunately, to be VBA (macro).
I did come across this page which starts off with "This wikiHow teaches you how to use the Power Query feature in Excel 2016 on a Windows and Mac computer." but I'm not so sure: How to Activate Power Query in Excel 2016: 9 Steps (with Pictures) I don't have a Mac so can't advise with any certainty, but if you find you can then that's the way to go. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Merging a table from multiple files into one table in a single file | LisaT | Excel | 3 | 08-28-2020 06:42 AM |
| How to compile text from multiple tables into a cell in a nested table | jrooney7 | Word VBA | 2 | 03-11-2019 07:55 AM |
| Combine multiple tables into one pivot table in order to do trend analysis | marelisev | Excel | 2 | 04-15-2017 08:30 AM |
 Copy table cell formatting across multiple cells / tables
|
pakistanray | Word Tables | 2 | 10-31-2011 08:07 AM |
|
Copying Multiple tables from excel into a single word document
|
dineshtgs | Word Tables | 1 | 04-07-2011 01:27 AM |
Windows 10 
Office 2019
Threaded Mode