Jefferis Peterson wrote:
I'm hesitating on the upgrade pricing to Office 2011 and hear Outlook is a disaster. I was waiting for Excel 2011 to get Macros back, but I'm wondering if I can do what I need to do in Numbers instead.
My main Macro that I use is merging columns not cells. IOW, a1 merges with b1, a2 with b2, etc., but not a1 with a2 and b2 and b1.
If there is no macro for this, is there an automator that would do that?
Thanks
Hi Jefferis,
Do you want to merge columns, or to merge the content of the cells in those columns?
Numbers can merge the content of the cells into a third cell using CONCATENATE (or the & operator), after which the original column pair may be deleted.
Numbers can merge adjacent cells into a single cell. The content of the two cells (data, or value calculated by a formula) is treated as a pair of text values, separated by a tab character.
Numbers does not support Macros, but may be scripted using AppleScript.
Numbers also supports Automator actions.
Whether either AppleScript or Automator could be used for this is outside my ken, but doesn't appear to be an insurmountable issue.
It's clear from your description that the desired result is that the cells on each row of the columns be merged while retaining the separation between rows. A clearer description of the result you want in each of those rows (ie. what the newly merged cell will contain) might help whoever takes on the task of buildiing a script or Automator action.
Regards,
Barry