I have an MS Excel spreadsheet with 250 rows, each row containing 4 columns of data (typical Excel columns A, B C and D).
I need to import this into an InDesign table that will look like this:
So basically columns A, B and C end up all in one row, but column D ends up in a row below A, B and C, and column D spans across the full width of columns A,B, and C.
Is there a way to do this without having to do it manually?
There is an InDesign Plug in you can buy called DataLinker (from teacup software) that will do this quite nicely, and will keep all the Data in one table.
If you want to use InDesign's native abilities, You could set up a data merge with a 2 row table in a text box set to fit the table exactly, and set your merge with 0 space between the records. The result would look like a single table, but would in fact be all separate tables in separate text boxes.