Hey guys, im looking for a vba to merge the current cell with all the blank cells below it. I'm automating a report, which turns into a pivot table, and then i need that pivot table in text format for something else. I was thinking of doing something like this and merge cells while recording.
but this also selects the next line with text. the data looks kind of like
<tbody>
</tbody>
I want it so it merges with the cells below, the data is like a sideways tree i guess?
Code:
Range("A91").Select
Range(Selection, Selection.End(xlDown)).Select
but this also selects the next line with text. the data looks kind of like
Shah, karan | ||
Jones, Dave | ||
Soni, Anand | ||
Thomas, Melissa | ||
Davis, Nathaniel | ||
Kent, Michael | ||
Lee, Sabrina | Patel, Shruti | |
Charles, Brent |
<tbody>
</tbody>
I want it so it merges with the cells below, the data is like a sideways tree i guess?