Creating an unique export data VBA Macro Function in Excel

0 votes

I was wondering if someone on this site might be able to offer insight in constructing a VBA function to perform the hard work because I've been given an existing spreadsheet with quite a bit of information to process.

My problem is that a lot of the data must be kept in its original format, even though it is necessary for our analytics that the data be transferred to the format displayed in the second image below.

Exists a function that iterates over all of the X headers, returns the value associated with the corresponding Y header, and then repeats this process for all possible combinations.

Original data format:

enter image description here

Desired Export data format:

http://i.imgur.com/Slf7SI7.jpg

Any help on this would be much appreciated! The origin data is constantly evolving so it will turn into a never-ending copy-paste exercise for me if I can't find a solution.

Nov 14 in Others by Kithuzzz
• 20,660 points
31 views

1 answer to this question.

0 votes
Unfortunately, the tables will vary in size. There is no need for headings in the output sheet. I think you are trying to delineate that you would prefer the data in different columns.

I hope this helps you.
answered Nov 14 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Removing specific rows in an Excel file using Azure Data Factory

Under the 'Source' tab, choose the number ...READ MORE

answered Sep 23 in Others by narikkadan
• 37,660 points
213 views
0 votes
1 answer
0 votes
1 answer

Runtime error 438 while importing data in excel from secured website using VBA

Replace With ieDoc.forms(0) .userType.Value = "1" ...READ MORE

answered Sep 23 in Others by narikkadan
• 37,660 points
102 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24 in Others by narikkadan
• 37,660 points
117 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
451 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,215 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
69 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
204 views
0 votes
1 answer
0 votes
1 answer

How to programmatically code an 'undo' function in Excel-Vba?

Add the command button to the worksheet ...READ MORE

answered Nov 25 in Others by narikkadan
• 37,660 points
23 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP