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 example...

excel

Formulas and Functions

transpose data

PascalKTeam
Oct 08, 2019
Paneross

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.

PascalKTeam

Iron Contributor

Oct 08, 2019

Paneross

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.

Paneross
Copper Contributor
Oct 09, 2019
Thank you, and I will leave you a rating!

Forum Discussion

Transpose 2 Columns with 100 Rows Help

Resources