Merging of rows by blanks in first column

[Yuriy_Karpilov]

Good day, community.

I have automatically updated pdf file with two columns.

This file I want to import to the excel file.

But problem is, it is importing with "main content title" in the first column and description to this each content in several rows after with blank cell under the "title".

If this file could be a static, it would not be a problem to spend some time and to merge by Transposing and merging each item.

But as soon as this pdf file updates time to time, this solution will not work properly during next update.

Is it some solution to merge "description" info in one cell belonging to one-cell "Title" automatically?

Idea to have in one row two columns: Column with title "SLxxxx-xxx" and column with full description.

BRGDS

[mrandall86 · Accepted solution]

Hi,

If I've understood correctly, you'd like to concatenate the strings in your second column, grouped by the string in your first column.

To do that:
1. Right click first column > fill > down

2. Right click first column > group by. Complete group by box as per below:

3. Add custom column > [AllData][second column]

4. Select to Extract Values

5. Add a delimitter of your choice

[Yuriy_Karpilov]

Super! This is great solution! Thank you very much! Really appreciated! 🤝