Hi how do i tranpose this
a
a
a
a
a
b
b
b
Into a a a a
B b b
A should be transpose to 4 different columns
b should transpose to 3 different columns
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tranpose function
0
Discussion
Your information is insufficient. Please post a sample workbook. Make sure you provide actual data examples. Substitutes like "a" and "B" will not suffice.
Variatus (rep: 4889) Oct 1, '20 at 11:33 pm
Answers
0
If you have 7 cells (say A1 to A7) vertically containing 4 x a and 3 x b:
a a a a b b b(or the numbers 1 to 7 say).
then select those cells and copy (Ctr C or right-click Copy). Then click on a cell outside that range (say B1), click the down arrow below the Paste icon in the Home Ribbon and the Paste Special... option. In the requestor, tick the Transpose checkbox (lower right) followed by OK.
Cells B1 to H1 will then contain the horizontal transposition:
a a a a b b bor in my suggested case of the numbers 1 to 7 initially, B1 to H1 would contain:
1 2 3 4 5 6 7I hope that's what you require (you'll need to remove the vertical cells). If not, please provide a file as Variatus suggested in the Discussion.