Data Transpose by Lookup

[Muhammad Owais Khan]

I have multiple data against multiple values, and I want to vertically lookup all the data from horizontal rows.

 

[RobP]

Hi ,

do you mean your data is already existing inside "Column B" (in many rows already ?)

Its not so easy for us to see as you've shown very small snapshot of data.

thanks
Rob

 

[alansidman]

If you are running XL2010 or later then you can unpivot your data using Power Query. In later versions, it is called Get and Transform Data and found on the Data Tab of the Ribbon. If you repost your data using XL2BB then we can show you exactly how to do this. Otherwise, google unpivot data with Power Query for a tutorial.