runmageddon
New Member
- Joined
- Oct 25, 2019
- Messages
- 3
Hi there,
I have a question related to creating a macro in VBA (data and desired outcome below). I have a table in Excel, where in column A and H I have data. In column A there are classes and in the column H are students. I would like to have only one row for one class and currently I have only one student in one row and there are blank columns as well. It looks like that: for example for class 1A I have in column A: and then in column H I have in the same row that "1A" Black, Jessica and then few rows below I have only Dark, James (with no "1A" in column A). I would like to have a macro that will copy Dark, James and others from this class into one cell - Black, Jessica. Could you please help me?
Data:
<tbody>
</tbody>
Desired outcome:
<tbody>
</tbody>
I have a question related to creating a macro in VBA (data and desired outcome below). I have a table in Excel, where in column A and H I have data. In column A there are classes and in the column H are students. I would like to have only one row for one class and currently I have only one student in one row and there are blank columns as well. It looks like that: for example for class 1A I have in column A: and then in column H I have in the same row that "1A" Black, Jessica and then few rows below I have only Dark, James (with no "1A" in column A). I would like to have a macro that will copy Dark, James and others from this class into one cell - Black, Jessica. Could you please help me?
Data:
A | B | C | D | E | F | G | H |
1A | Black, Jessica | ||||||
Dark, James | |||||||
2F | Snow, Mark | ||||||
Maurick, Adam | |||||||
Smith, John | |||||||
<tbody>
</tbody>
Desired outcome:
A | B | C | D | E | F | G | H |
1A | Black, Jessica Dark, James | ||||||
2F | Snow, Mark Maurick, Adam Smith John |
<tbody>
</tbody>