Need help to look values of the respective sku in different column

[michellejames]

Hi there,


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.


Regards,
Jame
IMAGE1
A: column header
B: values
C: part number

IMAGE2

IMAGE3

 

[michellejames]

Problem resolved.