Hello

I have a large spreadsheet of excel data formatted in colums when I need it
in rows.

Currently it is e.g.,

A K 1
A l 2
A m 3
A n 4
B k 1
B l 2
B m 3
B n 4

When we need it to look like e.g.,:
k l m n
A 1 2 3 4
B 1 2 3 4

I have figured out that I can cut and paste/transpose but please help me
keep my hair...is there a faster way?

Thanks for your help
Maria in New Zealand