I am working with linking a large set of data to maps that I have created in visio. I have multiple shapes on the maps in Visio, and I need to link the associated data to each shape in a format that is clear and easy to read. The problem I am finding, however, is that all data that I want to link to each shape needs to be in one single row (because the row transposes once you press CTRL+click on the shape to see the details on the left hand side of the visiowebpage file). Is there any way you can somehow place place an 'ENTER' or anything in one single cell, so my information is clearer. Here is an example of what I'm working with:




Name Assignments Location

Bob A D
B E
C


The problem with visio is that all of that info associated with BOB needs to be on one single row. So I concatenated all the info, and now the shape details on the left side of the screen reads like:

Name Bob

Assignments A, B, C

Location D, E


But my employer is not happy with that (because the information I am using is much more detailed than just A,B,C). I have tried doing &char(10)& and ALT+TAB in the actual excel file that I am pulling from, but once it is linked to a shape in Visio, the ENTERs simply disappear. Is there any way around this, so that I can format the shape data details table to be easier to read? Any tricks on formatting it, creating spaces?