abhishek_singhal
New Member
- Joined
- Oct 9, 2014
- Messages
- 4
Hi All
I have a data set like this:-
<tbody>
</tbody>
I want a row after each unique value in column A along with unique cell value pasted in the new row. Like the below mentioned:-
<tbody>
</tbody>
I want a macro for this. Thanks in advance.
Abhishek
I have a data set like this:-
Item Category | Item | Sales |
Shoes | Sports Shoes | 100 |
Casual Shoes | 200 | |
Others | Sandals | 300 |
Slippers | 400 |
<tbody>
</tbody>
I want a row after each unique value in column A along with unique cell value pasted in the new row. Like the below mentioned:-
Item Category | Item | Sales |
Shoes | ||
Shoes | Sports Shoes | 100 |
Casual Shoes | 200 | |
Others | ||
Others | Sandals | 300 |
Slippers | 400 |
<tbody>
</tbody>
I want a macro for this. Thanks in advance.
Abhishek