Transpose 2 Columns with 100 Rows Help
Good Afternoon, If I have data in Column A and B with a 100 rows of information when I go to copy, and Transpose on a new sheet it creates hundreds of columns for the entire thing. See my examples for what I'm trying to do. This is the unsorted data Desired Result: as you can see the desired result skips a row and then transposes the data for each new sample guy in Column A, and B. Thanks all, hope it makes sense.
