concatenate rows

  1. P

    Power Query won't concatenate some fields

    Hi, I have several tables imported from a Ms access db. I have edited some of the tables in power query. When I append all these separate tables into 1 and load it to a table the tables that I added custom columns to won't concatenate thier data with the rest. It should all be on one row...
  2. P

    Concatenate multiple rows

    I have sentences on adjacent rows. I am wanting to concatenate those into one row. What would the formula be to create that? Thank you for any assistance.
  3. madkinson

    CONCATENATE Each Row Into a Single Cell

    I have a 10,000 row spreadsheet where I need to convert each row (about 30 columns) into a single cell with a pipe ("|") separator. I've manually created a CONCATENATE statement (=CONCATENATE(A1,"|",B1,"|",C1,"|",D1,"|", ETC.), but that take way too long. I've tried Pearson's StringConcat, but...

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