Changing table format??

[MichaelRSnow]

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

 

[sdsurzh]

Hi,

Can you please refer the below links.

MS Excel: TRANSPOSE Function (WS)
How to transpose data in Excel - using formulas? - Introduction to TRANSPOSE Formula & other techniques | Chandoo.org - Learn Microsoft Excel Online

SK

 

[MichaelRSnow]

Hi,

Can you please refer the below links.

MS Excel: TRANSPOSE Function (WS)
How to transpose data in Excel - using formulas? - Introduction to TRANSPOSE Formula & other techniques | Chandoo.org - Learn Microsoft Excel Online

SK

Not sure this helps me,

I only have 1 column of data (A) 2,650 rows long, which I want to convert to a table grid that is 530 x 5 (B:F)