NerdyDataGuy
New Member
I have a spreadsheet that needs manual adjusting. I am sure there has to be a macro that can do the same things.
Example: questions are lined up 1, 1a, 1b, etc through 1.d.ii Each one is a different question.
The data for question 1 is mostly a straight table of data.
Question 1.a needs to be appended to the ended of the table above based on (firm name and metric). The row count does match.
I highlighted the table hierarchy / table structure fields in yellow and orange. Then the data I want to move is highlighted in green to the section of green that is blank at end of the obvious table. Then highlighted the fields that want to be merged in grey.
Example: questions are lined up 1, 1a, 1b, etc through 1.d.ii Each one is a different question.
The data for question 1 is mostly a straight table of data.
Question 1.a needs to be appended to the ended of the table above based on (firm name and metric). The row count does match.
I highlighted the table hierarchy / table structure fields in yellow and orange. Then the data I want to move is highlighted in green to the section of green that is blank at end of the obvious table. Then highlighted the fields that want to be merged in grey.