Hi there,
I have a table as attached "Table-1". How could I make it with fastest way to reshape like "Table-2"? My best way to make it is to copy "Module 1" and paste, then filter "Module 1" w/o choosing blanks, copy Part numbers and usage quantities and paste to near of "Module 1". And same processes for all modules. As you can guess, it's taking too many hour because my table is very big.
Waiting for valuable feedbacks.
Table-3.JPG
Thank you.
Bookmarks