Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-18-2018, 09:57 AM
mpapreja mpapreja is offline Conversion of Columnwise Bill of Material into Rowwise Bill of Material using Excel Macro VBA Windows 10 Conversion of Columnwise Bill of Material into Rowwise Bill of Material using Excel Macro VBA Office 2016
Novice
Conversion of Columnwise Bill of Material into Rowwise Bill of Material using Excel Macro VBA
 
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, 12 views)
Reply With Quote
 

Tags
bill of materials, bom, transpose



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conversion of Columnwise Bill of Material into Rowwise Bill of Material using Excel Macro VBA BOM (bill of material) umairn Project 1 04-17-2017 02:11 PM
Conversion of Columnwise Bill of Material into Rowwise Bill of Material using Excel Macro VBA Integrating Bill Of Materials (BOM) GRT45 Project 1 03-16-2017 10:26 PM
Conversion of Columnwise Bill of Material into Rowwise Bill of Material using Excel Macro VBA Inserting material after Endnotes ClaireB Word 19 10-01-2015 07:54 PM
Conversion of Columnwise Bill of Material into Rowwise Bill of Material using Excel Macro VBA Project 2013 reading material Steve. Project 3 05-17-2014 07:08 AM
Conversion of Columnwise Bill of Material into Rowwise Bill of Material using Excel Macro VBA Purging duplicated material in a document NepalKat#1 Word 1 09-03-2011 05:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft