Hello all,

I have a question as to how I can transpose lots of data that's stacked ontop of each other, into rows that fit into their general categories. In the attached below, I have column A, and Column B. I want the data to be transposed by "looking up" if you will off column A, than posting the B value into its transposed area. Without manually changing the Array each time, I can't get this to work with a Vlookup, I was wondering if there was another way via maybe a conditional index, or something that would work? Any help is appreciated.

Thanks,

Math

Copy of AWP corrugated specs.xlsm