View Single Post
 
Old 05-18-2018, 09:57 AM
mpapreja mpapreja is offline Windows 10 Office 2016
Novice
 
Join Date: May 2018
Posts: 9
mpapreja is on a distinguished road
Default Conversion of Columnwise Bill of Material into Rowwise Bill of Material using Excel Macro VBA

Dear Experts
I am having vertical Bill of Materials (BOMs) of my 1000s of items in Columnar form. In need to convert it into rowwise format BOMs.



The source BOM and desired output is shown in the attached excel file.


Can somebody help my achieving the above desired output?


Thanks for your help in advance.

The above query also posted on following forum:-


https://social.technet.microsoft.com...ba?forum=excel
Attached Files
File Type: xlsx 1-BomTranspose Macro - Forum.xlsx (11.2 KB, 5 views)
Reply With Quote