MichaelRSnow
Active Member
- Joined
- Aug 3, 2010
- Messages
- 409
Hi all, Is there a formula that can be copied down from columns B to F that will convert a list of data 65k rows long in column A into a table i.e.
A1 data shows
1
2
3
4
5
1
2
3
4
5
1
2....
I want to convert this to
B C D E F
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
A1 data shows
1
2
3
4
5
1
2
3
4
5
1
2....
I want to convert this to
B C D E F
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5