Transpose At Every Blank Row

asked 2018-10-19 22:45:45 +0100

Prasanjith gravatar image

I was wondering if i could transpose data that is in a column at the end every blank cell into new cells in a row. Do i have to use macro???

A1
A2
A3

B4
B5

C6
C7
C8
C9

becomes
A1 | A2 | A3
B4 | B5
C6 | C7 | C8 | C9

edit retag flag offensive close merge delete