Merging multiple cells in a column into one and save format

mjwood

New Member
Joined
Jul 16, 2015
Messages
1
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>
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,215,793
Messages
6,126,934
Members
449,349
Latest member
Omer Lutfu Neziroglu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top