将行转换为多列 [英] converting rows into multiple columns

问题描述

需要索引函数的帮助。我有一行A行上的数据，需要将它们分割成两行，而不是按字母顺序排列。
如图所示。

need help with index function. i have a bunch of data on row A and need to split them to two rows instead but retaining their alphabetical order. as the image shows.

example of what i need

解决方案

Put this following standard formula in C1,

=INDEX($A:$A, INT((ROW(1:1)-1)/7)*14+MOD(ROW(1:1)-1, 7)+SIGN(COLUMN(A:A)-1)*7+1)&""

Copy it to E1 then fill both down until you run out of entries.

    

这篇关于将行转换为多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！