I'm creating a booklet with indesign and I am trying to copy data from an excel spreadsheet into an indesign table. I was given an excel spread sheet with the a list of peoples names, their titles and their companies. I have to put a name in one column and then in the other put the company name and their title, as the picture (1) here illustrates:
Where the problem arises is trying to merge two cells in excel so that they are underneath each other and then paste it into one cell in the indesign table.
I tried to combine column C and D (as IN THE PICTURE) and insert a new line between the columns. (=C1&CHAR(10)&D1)
This worked in Excel but when copying it into indesign they do not go underneath each other but into different cells and they also show " quotation marks around the text.
I know there must be a relatively simple way of doing this in Excel and then copying it into indesign but I have run out of ideas. Can anyone tell me the best way to approach this as I am stuck. Thanks in advance.