Hi all,
I have a spreadsheet where I have column B that has an "indicator." essentially I have marked all rows that have the same content in column C with a repeating number ..
What I want to do is merge the entire row with vba for all the rows that have the same number (increase by 1 each time) while only merging column C's cells together and keeping all content in column D and column E in the format of "content-in-row-1, content-in-row-2, content-in-row-3, ... content-in-row-n"
Also the rows (after being merged) that are empty will be deleted. We're NOT creating a new sheet or new range for the newly merged cells, just trimming down the current sheet
Heres a picture of what I mean if you have any questions please do not hesitate to ask!
screenshot.JPG
Please help me! I really need to solve this challenge and I appreciate for everyones time!
Bookmarks