Forum Discussion
How to transpose columns, creating new line based on condition
I have data which is as below: AAA01 Company 1 Phone number 1 Post code 1 Email1 Name 1stNumeric 1 2ndNumeric 1 My data then repeats in this pattern for ~100 rows. ...
Let's say your data are in A1 and down.
Enter the following formula in C1:
=INDEX(A:A,8*ROW()-7)&""
and in D1:
=INDEX(A:A,8*ROW()-3)&""
Select C1:D1, then fill or copy down as far as you want.