Merging or Combine Sheets in Numbers?
I have a spreadsheet (orginally from Excel) that has separate worksheets for each month of the year. I want to merge this data all into one sheet in Numbers? Is there a way to do this?
I have a spreadsheet (orginally from Excel) that has separate worksheets for each month of the year. I want to merge this data all into one sheet in Numbers? Is there a way to do this?
If you have the Excel application, you can copy the data in Excel and Paste into Pages. Or, you can import to Pages and then Copy the individual tables and Paste into one larger table. Results should be the same.
This will require some work, but it's not difficult work. Select the subtable and Command-C. Create a blank row at the bottom of your master table and select the leftmost cell in that column, then Command-V. Repeat for each subtable.
Regards,
Jerry
If you have the Excel application, you can copy the data in Excel and Paste into Pages. Or, you can import to Pages and then Copy the individual tables and Paste into one larger table. Results should be the same.
This will require some work, but it's not difficult work. Select the subtable and Command-C. Create a blank row at the bottom of your master table and select the leftmost cell in that column, then Command-V. Repeat for each subtable.
Regards,
Jerry
Merging or Combine Sheets in Numbers?