Forum Discussion
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.
VBA solutions is done and can be found here: https://kteamch-my.sharepoint.com/:x:/g/personal/pascal_kiefer_kteam_ch/EWkC27v2napNu1N-NAEsumcBUyP1YkQxs9BlQtUcB58TGQ?e=oDSlQl&download=1
Please note that I'm looping through the VBA 100 times. In case there are more (or less) sample guys, this number can be adjusted in the VBA code. Just look for following line: For sampleGuy = 1 To 100
In case my solutions worked, I would very much appreciate if you clicked on the logo in the file and leave a rating or review on google.
2 Replies
VBA solutions is done and can be found here: https://kteamch-my.sharepoint.com/:x:/g/personal/pascal_kiefer_kteam_ch/EWkC27v2napNu1N-NAEsumcBUyP1YkQxs9BlQtUcB58TGQ?e=oDSlQl&download=1
Please note that I'm looping through the VBA 100 times. In case there are more (or less) sample guys, this number can be adjusted in the VBA code. Just look for following line: For sampleGuy = 1 To 100
In case my solutions worked, I would very much appreciate if you clicked on the logo in the file and leave a rating or review on google.
- Thank you, and I will leave you a rating!
