Macro to Combine Multiple Rows into One Row
Hello - I have a scenario of multiple rows of data being created for a single data identifier. The goal is to combine these multiple rows for a single data identifier into one single row. In my example, I have 17 columns of data attributes (Column A thru Q) and 1 column of data identifier (Column R).
In the attached, you'll noticed the greyed examples that I am trying to combine into one row. I'm looking for a macro to be able to export the result into a new tab.
Any help would be immensely appreciated!
|