•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Special Transpose task without VBA?
Hello Excel community. First time poster.
Does any one know a technique or trick to do a transpose on a range of columns to create rows and transpose those columns without using VBA? Here's a simple example I'm thinking of:
Row C1 C2 C3 C4
1 a b c d
2 a b c
3 a b
Transpose to this format:
Row C1
1 a
1 b
1 c
1 d
2 a
2 b
2 c
3 a
3 b
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#row zero
#Excel alternatives for data analysis
#real-time data collaboration
#Transpose
#Excel
#VBA
#columns
#rows
#range
#technique
#trick
#format
#community
#data
#C1
#creation
#example
#input