AVRAHAMROOS
New Member
- Joined
- Nov 24, 2016
- Messages
- 21
I haven't been here for a long time but you guys have helped me in the past immensely when I was building an excel based text analysis tool (see https://www.academia.edu/30391368/PDD_Poetic_Devices_Detector_)
I am now busy with something else text based and need more help.
Given a table with several similar texts in each column - one word per cell e.g.
<tbody>
</tbody>
I need a way to merge certain cells vertically while keeping all text and do this simultaneously for each text version (=column). E.g. How do I merge "bread of affliction" (or "food of affliction") in rows 6-8 for columns A, B, C, D?
Ideally, it should be done by highlighting rows 6-8 and hitting a macro/ button
The end result should look like this:
<tbody>
</tbody>
Thanking you in advance,
Avraham
I am now busy with something else text based and need more help.
Given a table with several similar texts in each column - one word per cell e.g.
A | B | C | D | |
1 | Lo! | Lo! | ||
2 | This | This | THIS | this |
3 | is | is | is | is |
4 | as | as | ||
5 | the | the | the | the |
6 | bread | bread | food | bread |
7 | of | of | of | of |
8 | affliction | affliction | affliction | affliction, |
9 | which | which | which | which |
10 | our | our | our | our |
11 | ancestors | forefathers | fathers | ancestors |
12 | did | |||
13 | ate | ate | eat | ate |
<tbody>
</tbody>
I need a way to merge certain cells vertically while keeping all text and do this simultaneously for each text version (=column). E.g. How do I merge "bread of affliction" (or "food of affliction") in rows 6-8 for columns A, B, C, D?
Ideally, it should be done by highlighting rows 6-8 and hitting a macro/ button
The end result should look like this:
A | B | C | D | |
1 | Lo! | Lo! | ||
2 | This | This | THIS | this |
3 | is | is | is | is |
4 | as | as | ||
5 | the | the | the | the |
6 | bread of affliction | bread of affliction | food of affliction | bread of affliction, |
7 | which | which | which | which |
8 | our | our | our | our |
9 | ancestors | forefathers | fathers | ancestors |
10 | did | |||
11 | ate | ate | eat | ate |
<tbody>
</tbody>
Thanking you in advance,
Avraham