I am pulling data from other software as a csv file. There are ~47 to 60 rows each with duplicate data in column A. With the first set of duplicate rows in column A, I need to transpose column E for the headings and transpose column F for the data. The remaining duplicate rows will have column F transposed. I would like to set this up using macros/vba as this data will be downloaded periodically with different users. How do I define the range of duplicate rows as there will not be a definite number of duplicate rows each time?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Manipulate Duplicate Rows??
- Thread starter kls
- Start date
