COLUMNS

Copper Contributor

I have one column with 80 lines of data that I want to change into multiple column headings. Eg, line 2 of data moves to a column heading next to datum on line one, line 3 to a column heading next to datum that was on line 2, etc.

1 Reply

@Walter8544 

Calling the existing column 'oneColumn', the formula

= WRAPROWS(oneColumn, 5)

returns 5 columns of 20 items.