Excel 2007 : Transposing Values w/ Duplicate Fields (Vertically Arranged) Horizontally

Hi!

I have here an file extracted from a database that is arranged vertically (Column A is the Fields, Column B is the values). Now from the vertically arranged values, they can be divided into one set. On the file attached, each set's start point is tagged as "F" in column A and the end point is tagged as "E' in column B.

What I want to happen is to transpose all values from vertical to horizontal, but values should already be consolidated according to fields (since the fields in Column A are duplicate fields already, but the values counterpart in Column B are different). No need to transpose all items in Column A, just the 352 common fields.

To better understand, I've attached the file of reference and the output that should come out.

Hope you can help me out on this. Still figuring if I can do this in Access, but hopefully Excel should be enough

I just noticed that discrepancy as well. But I think the bottom line result that I want here is that all values for "F" should be aligned into one column, all the values for "E" should be aligned in one column, etc... I was thinking of something similar to a VLOOKUP but instead of getting the top value, you retrieve all the values.

Originally Posted by arlu1201

A vlookup will not help you.

The macro was working out, but its creating an issue since the number of rows is not consistent. Will check again on how i can restructure the code.

Any luck? I am starting to realize that a lookup won't help. No possible formula or option where you can lookup a whole range of values

Originally Posted by arlu1201

Try using the code as the attached file. I have copied the code to a blank file (macro file). Copy the headings you require into sheet 2 column A of the macro file. The output will appear in Sheet 1 of the macro file.

Hey, sorry it took a while for me to respond. I tried the code you gave and it worked out great! Thanks for your help there. Problem is, the disparity of the number rows affected the file that's why some of the fields there were misplaced, usually it's a row higher. I'll try my luck to find a way to iron this out, maybe through MS Access.