SOLVED
Home

Transpose 2 Columns with 100 Rows Help

%3CLINGO-SUB%20id%3D%22lingo-sub-900768%22%20slang%3D%22en-US%22%3ETranspose%202%20Columns%20with%20100%20Rows%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-900768%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Afternoon%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20have%20data%20in%20Column%20A%20and%20B%20with%20a%20100%20rows%20of%20information%20when%20I%20go%20to%20copy%2C%20and%20Transpose%20on%20a%20new%20sheet%20it%20creates%20hundreds%20of%20columns%20for%20the%20entire%20thing.%20See%20my%20examples%20for%20what%20I'm%20trying%20to%20do.%3C%2FP%3E%3CP%3EThis%20is%20the%20unsorted%20data%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20347px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135909i11984FFD4750E4BF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Transpose%20Data.png%22%20title%3D%22Transpose%20Data.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDesired%20Result%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135911i226EBDA8202F00BE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Result.png%22%20title%3D%22Result.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eas%20you%20can%20see%20the%20desired%20result%20skips%20a%20row%20and%20then%20transposes%20the%20data%20for%20each%20new%20sample%20guy%20in%20Column%20A%2C%20and%20B.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20all%2C%20hope%20it%20makes%20sense.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-900768%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etranspose%20data%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-900790%22%20slang%3D%22en-US%22%3EBetreff%3A%20Transpose%202%20Columns%20with%20100%20Rows%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-900790%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377119%22%20target%3D%22_blank%22%3E%40Paneross%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EIs%20this%20a%20one%20time%20task%20or%20do%20you%20have%20to%20do%20this%20on%20a%20regular%20basis%3F%20I%20could%20try%20to%20create%20a%20VBA%20solutions%20if%20you%20like%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-900893%22%20slang%3D%22en-US%22%3ERe%3A%20Transpose%202%20Columns%20with%20100%20Rows%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-900893%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377119%22%20target%3D%22_blank%22%3E%40Paneross%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVBA%20solutions%20is%20done%20and%20can%20be%20found%20here%3A%20%3CA%20href%3D%22https%3A%2F%2Fkteamch-my.sharepoint.com%2F%3Ax%3A%2Fg%2Fpersonal%2Fpascal_kiefer_kteam_ch%2FEWkC27v2napNu1N-NAEsumcBUyP1YkQxs9BlQtUcB58TGQ%3Fe%3DoDSlQl%26amp%3Bdownload%3D1%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFile%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20note%20that%20I'm%20looping%20through%20the%20VBA%20100%20times.%20In%20case%20there%20are%20more%20(or%20less)%20sample%20guys%2C%20this%20number%20can%20be%20adjusted%20in%20the%20VBA%20code.%20Just%20look%20for%20following%20line%3A%26nbsp%3BFor%20sampleGuy%20%3D%201%20To%20100%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20case%20my%20solutions%20worked%2C%20I%20would%20very%20much%20appreciate%20if%20you%20clicked%20on%20the%20logo%20in%20the%20file%20and%20leave%20a%20rating%20or%20review%20on%20google.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-902416%22%20slang%3D%22en-US%22%3ERe%3A%20Transpose%202%20Columns%20with%20100%20Rows%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-902416%22%20slang%3D%22en-US%22%3EThank%20you%2C%20and%20I%20will%20leave%20you%20a%20rating!%3C%2FLINGO-BODY%3E
Paneross
Occasional Contributor

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

Transpose Data.png

 

Desired Result:

Result.png

 

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.

 

 

2 Replies
Solution

@Paneross 

 

VBA solutions is done and can be found here: File 

 

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. 

 

Highlighted
Thank you, and I will leave you a rating!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies