Sunday, January 12, 2014

Transpose every 3 rows to single row

Example of data:
John Doe
Some street
1234567890
Joanna Doe
Sesame street
654321

Expected result:
John Doe    Some street    1234567890
Joanna Doe Sesame street 654321

Data on A1 to A6

Formula on B1:
=INDEX($A$1:$A$6;ROWS(A$2:A2)*3-3+COLUMNS($A2:A2))

No comments:

Post a Comment