Concatenate variable number of lines within a column

**ferndiazabarca** · 05-03-2015, 12:14 AM

Hi,
I would like your help with the following issue

I have many questions in a column (column c) and each question is in several lines, there is not an exact number of lines, some times a question can occupy 2 lines and some others 10 or more lines,
I want to concatenate the different lines of each question within a single line . I also have a number (100) in colum B, these number are in the exact same line as the beginning of each question, maybe I can use these numbers as delimiters for the concatenate formula. In the excel file there is an example of what I have and what I want
Thank you very much for your help

Fernando

**sktneer** · 05-03-2015, 01:14 AM

Hi Fernando,
Welcome to the forum.

If you are open to a VBA solution to this, please find the attached workbook and click on the button on the sheet to run the macro to get the desired output.
Enable the macros while prompted after opening the workbook.

**ferndiazabarca** · 05-03-2015, 01:35 AM

Hi sktneer,
very good solution, but I realized that in some cases there is not space between the questions and in some other cases there are spaces between the answers and the macro does not do the right concatenation in those cases. The file that I uploaded is an example, the real columns are different, how can I change the column in the macro?

the questions are like here

question1
a
b

c
d

question 2
a
b
c
question 3

a
b
c

d
question 4

a
b
c...
I appreciate your help
Thanks

Fernando

**sktneer** · 05-03-2015, 01:52 AM

Something like this?

**sktneer** · 05-03-2015, 01:59 AM

Here is the modified code with your new sample workbook from post#3.

**ferndiazabarca** · 05-03-2015, 02:03 AM

Sktneer you are a Master, that is exactly what I need. In the example my column source is C, if I need to change the colum source lets say M, where do I need to put it in the Macro

Thank you very much

Fernando

**sktneer** · 05-03-2015, 02:13 AM

Here is the code used with some added comments......
Make the changes to suite your requirement.

Please Login or Register  to view this content.

**ferndiazabarca** · 05-03-2015, 02:18 AM

Sktneer

Thank you very much
you really are a genious I was struggling to try to make it work using concatenate but I couldn't
Thank you very much
Muchas gracias
Merci beaocoup

Fernando

**sktneer** · 05-03-2015, 02:22 AM

You're welcome. Glad I could help.
De nada. Me alegro de poder ayudar.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

tener cuidado

**ferndiazabarca** · 05-03-2015, 02:26 AM

Muchas gracias
Te deseo todos los exitos del mundo
un fuerte abrazo
Fernando

**sktneer** · 05-03-2015, 02:29 AM

Muchas gracias.
Era placer trabajar con usted .
Todo lo mejor

Concatenate variable number of lines within a column

LinkBack

Thread Tools

Rate This Thread

Display

Concatenate variable number of lines within a column

Re: Concatenate variable number of lines within a column

Re: Concatenate variable number of lines within a column

Re: Concatenate variable number of lines within a column

Re: Concatenate variable number of lines within a column

Re: Concatenate variable number of lines within a column

Re: Concatenate variable number of lines within a column

Re: Concatenate variable number of lines within a column

Re: Concatenate variable number of lines within a column

Re: Concatenate variable number of lines within a column

Re: Concatenate variable number of lines within a column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Variable number of lines in a Linest

[SOLVED] Concatenate variable number of lines

How to concatenate a variable number of rows/cells based on multiple criteria?

Concatenate address lines of varying number

Concatenate (combine) Header Row with Variable Number of Detail Rows

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions