I am running Windows 7 on my PC with Excel 10. I have exported data from Filemaker to a spread sheet. There are 10 columns and hundreds of rows of data. The data in two of the middle columns was exported so that each line of data was inserted into a separate row. The two columns with multiple rows of data actually may be as little a one row and as many as nine rows. The data in the rows of the two middle columns are related to each other and must end up side by side when they are merged into a single cell in their respective columns. I am wondering if there is a VBA solution that would allow me to select the two columns with multiple rows and convert them into one cell with multiple lines of text within the cell. Thanks in advance for any help you may provide.
<tbody>
</tbody>
<tbody>
</tbody>