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.

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 write a macro as the solution.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

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%...

Q:

answer this workbook please : https://ccnymailcuny-my.sharepoint.com/:x:/g/personal/malam008_citymail_cuny_edu/EQNuFz9ESMBBi1zuzV0w9uYB2I2aaFXcclMlPPc6JndcLQ?e=12fYP0 18 19 Horizontal Analysis 0...

Q:

Drive (miles) 36 20 88 6 71 42 76 63 36 63 38 28 55 33 40 80 86 83 4 39 25 25 54 54 81 73 29 76 78 77 42 36 71 94 6 State MI IL CA IL MI IL NY PA TX NY OR NY OH SC IL NV FL FL NY SC CA GA FL CA CA FL...

Q:

Name:_____________________________________ Spreadsheet 1, Original Paper Appliances listed: 8 and 2 standby /6 Minimum 1 page, 350 words /2 CO2, wattage, and hours for each given /6 Correct format,...

Q:

Averell Cabinetry Case Overview This case is presented as close as possible to the way you may encounter it in working life. Your role is that of a newly hired HR manager. You will learn about the...

Q:

AH ? CGOP ... Document1 Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Calibri (Bo... v 12 A" A Aa Ap EEVEEVEE AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb(...

Q:

Instructions: Your first task will be to determine how many people have applied for which areas of study thus far. To do this: Open the file Highlight the column "Desired Area of Study" Select...

Q:

Return Predictability along the Supply Chain F.AJ inancial Analysts Journal Volume 66 . Number 3 @2010 CFA Institute these two studies were based on the idea that the 2007, the last month for which...

Q:

Can someone help me correct these two things for my project? (1) Residential Service Revenue: Revenue is recognized on a monthly basis ($18 per month). Therefore if the contract starts from 2/1/2015,...

Q:

Can someone help me correct these two things for my project? (1) Residential Service Revenue: Revenue is recognized on a monthly basis ($18 per month). Therefore if the contract starts from 2/1/2015,...

Q:

If the Power supply is + 12volts and -12volts. The inverting input is 3.6 volts and the non-inverting input is 3.8 volts. What is the output voltage value?

Q:

Write a summary on Cherns Case Study i. Identify four criteria for resume evaluation. Complete the criteria naming sections of the table which is given in that case study. ii. Evaluate each...

Q:

Apple stock is listed on the nasdaq exhange. Can the stock be traded off the exchange? Explain with rules of the national market system.

Q:

7 A judicial decision on the constitutionality of an executive order that limits certain state actions is a . beyond the jurisdiction of the courts. b . a question of fact. C . a summary judgment. d...

Q:

1. Is cyberwarfare a serious problem? Why or why not? In July 2010, reports surfaced about a Stuxnet worm that had been targeting Irans nuclear facilities. In November of that year, Irans President...

Q:

4. What should MWEB do in the future to avoid similar incidents? BMWEB, launched in 1997, became South Africas leading ISP in 1998. It has established itself as a company that provides a cutting-edge...

Q:

2. What is the business value of security and control?