Neel_07ee55
New Member
- Joined
- Sep 21, 2016
- Messages
- 2
Hello All,
Below is my input table:
<colgroup><col><col></colgroup><tbody>
</tbody>
I want result as stated below:
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
Note:
Count of "Compound Folder Name"/"File Name" may vary.
Kindly provide macro/VBA program for the same.
Thank you & Regards,
Neelkumar Solanki
Electrical Engineer
India
Below is my input table:
Compound Folder Name | File name |
electrical documents | a.pdf |
electrical documents | b.dwg |
electrical documents | c.pdf |
electrical documents | d.xyz |
mechanical documents | a1.pdf |
mechanical documents | b1.dwg |
instrumentation documents | a2.pdf |
instrumentation documents | b2.dwg |
<colgroup><col><col></colgroup><tbody>
</tbody>
I want result as stated below:
Compound Folder Name | File name1 | File name2 | File name3 | File name4 |
electrical documents | a.pdf | b.dwg | c.pdf | d.xyz |
mechanical documents | a1.pdf | b1.dwg | ||
instrumentation documents | a2.pdf | b2.dwg |
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
Note:
Count of "Compound Folder Name"/"File Name" may vary.
Kindly provide macro/VBA program for the same.
Thank you & Regards,
Neelkumar Solanki
Electrical Engineer
India