Question
I have an excel sheet that has many rows that has an index and multiple values in separate columns. Example below A1 B1 C1 D1
I have an excel sheet that has many rows that has an index and multiple values in separate columns. Example below
| A1 | B1 | C1 | D1 |
| EUR/USD | 0.19% | 1.06% | 2.55% |
| USD/JPY | -0.44% | 0.54% | -2.48% |
| GBP/USD | 0.48% | 0.33% | 2.71% |
| USD/TRY | -0.01% | 0.28% | 0.80% |
| USD/CHF | -0.38% | 0.33% | -1.37% |
However I want to convert that to look like this. Each index has key associated its its value in that row.
| A1 | B1 |
| EUR/USD | 0.19% |
| EUR/USD | 1.06% |
| EUR/USD | 2.55% |
| USD/JPY | -0.44% |
| USD/JPY | 0.54% |
| USD/JPY | -2.48% |
| GBP/USD | 0.48% |
| GBP/USD | 0.33% |
| GBP/USD | 2.71% |
| USD/TRY | -0.01% |
| USD/TRY | 0.28% |
| USD/TRY | 0.80% |
| USD/CHF | -0.38% |
| USD/CHF | 0.33% |
| USD/CHF | -1.37% |
please create a macro or formula that does this
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Public Finance
Authors: Harvey Rosen, Ted Gayer
8th Edition
0073511285, 9780073511283
