hokiebigtackle
New Member
- Joined
- Jan 7, 2014
- Messages
- 3
Ok, here's the scenario:
I need a formula that will merge cells from column B and separate with a comma at each change of value in column A. This would be fairly easy except they are 1000's of rows and each and the number of rows for each different value in column A varies anywhere from 6 rows to 12 rows. If each value in column A had the same number of rows, I would create a formula like this =(B1&","&B2&","&B3&","&B4...) and just copy and paste the formula on the first line of each different value, but because the # of rows varies, each paste has to be adjusted by adding additional cells or deleting cells from the formula. I use Excel daily and feel like I'm pretty knowledgeable usually but this is way above my pay grade. :wink: Can anyone help me?
I need a formula that will merge cells from column B and separate with a comma at each change of value in column A. This would be fairly easy except they are 1000's of rows and each and the number of rows for each different value in column A varies anywhere from 6 rows to 12 rows. If each value in column A had the same number of rows, I would create a formula like this =(B1&","&B2&","&B3&","&B4...) and just copy and paste the formula on the first line of each different value, but because the # of rows varies, each paste has to be adjusted by adding additional cells or deleting cells from the formula. I use Excel daily and feel like I'm pretty knowledgeable usually but this is way above my pay grade. :wink: Can anyone help me?