I am in puzzle. I have several sku with same header and values but they are located in different column horizontally. See image1.jpg. Now I have manually arrange them like same header in one column below their respective values. see image3.jpg.
I think macro will not work. May be some look up formula will work. I will create table sky and header like "image2.jpg" and some lookup function look the values in image1.jpg table and filled in blank header column.
Please let me know if this possible. OR do you have different idea for it. Manually create so much pain in my brain.
A: column header
C: part number