I have this very large table that's 29 columns wide and over 10,000 rows. Is there a way to have a piece of VBA code that does the following:
Create a second table to the right side of the first table starting at column AO
The first row of the second table will be a copy of the first rows headers
The second row of the second table will be a copy of the second row from the first table (first instance of the value in Column D)
The third row of the second table will be a copy of the first tables next row only if the value in Column D changes.
The forth row will of the second table will be a copy of the first tables next row only after the value in Column D changes again.
This would repeat until the last row. I attached what the data looks like and a sample of what the output should resemble.
The end result is basically a new table containing only the first instance of a row when ever the value in Column D changes.
Any help would be very appreciated.
Bookmarks