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, 2022 in Others by Kithuzzz
• 27,160 points
78 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, 2022 by narikkadan
• 50,080 points

Related Questions In Others

0 votes
1 answer

Using Visual Basic to pull data from within a range to use in an Excel function

Use AVERAGEIFS instead of the full range. ...READ MORE

answered Jan 14 in Others by narikkadan
• 50,080 points
30 views
0 votes
1 answer

How do I use the Indirect Function in Excel VBA to incorporate the equations in a VBA Macro Function

Try this: Sub Test() Dim str As String: str ...READ MORE

answered Jan 19 in Others by narikkadan
• 50,080 points
41 views
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, 2022 in Others by narikkadan
• 50,080 points
514 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 50,080 points
1,032 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,740 points
518 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,370 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, 2022 in Others by gaurav
• 22,940 points
110 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, 2022 in Others by Edureka
• 13,640 points
270 views
0 votes
1 answer

Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 50,080 points
134 views
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, 2022 in Others by narikkadan
• 50,080 points
96 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