0

I have multiple block of data as below and I want to transform it from column to row. Im new to excel so I hope you guys can help me with.

e.g: input:

A AA 1 2 3 4 5
B BB 1 2 3 4 5
C CC 1 2 3 4 5

expect output:

A AA 1
     2
     3
     4
     5
B BB 1
     2
     3
     4
     5
C CC 1
     2
     3
     4
     5
2
  • 1
    A AA in the same cell?
    – Lee
    Commented Mar 28, 2023 at 9:26
  • no, they are in different cells , but I solve this problem Commented Mar 29, 2023 at 3:30

0

You must log in to answer this question.

Browse other questions tagged .