Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design And Relational Theory Normal Forms And All That Jazz

Authors: Chris Date

1st Edition

1449328016, 978-1449328016

More Books

Students also viewed these Databases questions

Question

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

Answered: 1 week ago