I have attached a sample file of the results I want. Original Data is on Sheet 1 - Transposed Data is on Sheet 2.
What I am looking for is a macro that will find all rows of the same LOT# and transpose the data to one row. Once the data is transposed for that lot it should delete the remaining rows and move the next LOT#.
There are over 200,000 rows on my original sheet, so this is just a sample. Also, the number of rows per LOT can vary. Some only have 2 rows, some 3, and some 5.