This is not a simple transposing, you need vba, but you don't like it, why ?