This may be impossible to do, but allow me to explain what we are planning.
We have an Excel sheet with hundreds of rows. In each row they are three main columns that we need to get into InDesign and be in a table, as well as further columns to the right that are going be be in rows below once in InDesign.
As such, the table in InDesign is going to have multiple rows, with the first row containing the three cells and other rows containing either one cell, or multiple cells. I think this may be impossible, but is there a code that can be placed into Excel to force InDesign to place text into subsequent rows? At the moment, on pasting, InDesign just automatically adds extra columns.
Any help appreciated.
You might want to think about setting this up as a Data Merge project.
Screenshots would help, but I suspect you would need to gather the required information in Excel using another sheet. Name that range and place that in InDesign.
Thanks Peter and Bob.
I suspected as much but thought I better ask as a designer I work with was planning this method and wanted to know if it was feasible.