Issue translating table data to column format with firm + year = datapoint

Hi All,

First post here. I have a variable I am using for research which is a % point in a given year for a firm. The results I have managed to extract from my database can be found i the picture below. Now, I am having trouble figuring out how to transform the results in the table into the example posted in the other picture, that would be the end result I am aiming for. There must be a combination of formulas to do this, but my attempts so far have been without success.

Anyone have an idea on how to tackle this?

Best,

Jody

PowerQuery may be a solution, but post#2 is still on

Power Query for

• Excel 2010 Pro Plus or Excel 2013 Pro Plus can be downloaded as free add-in from MS site (choose correct version). I suggest Power Pivot also
• Excel 2016 or Excel 365 is built-in, aka Get&Transform
• PowerQuery works with M-language and does not contain any classic formulae or vba code
• What PowerQuery is? see here: Getting Started with PowerQuery (Get&Transform) in Excel

Here is the dummy file, the output is green is how I would like my variables to be displayed, but I have not found a way to do this non manually.

Thanks in advance.

This is exactly what I want! Thank you very much.

You are welcome

Read me Try to avoid joining to my Black List by doing this below If that takes care of your original question, & to say Thanks and for better Motivation, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. If you did it already - ignore it. Thank you.

Any code you could share with me on how you did this? I have been trying with power query but haven't managed to figure it out.

Code? Sure....

Please Login or Register  to view this content.