I have a table of rows and 9 columns and I am willing to have each row separated into three columns and three rows. For example:
On A1:I1, I have:
1,2,3,4,5,6,7,8,9
I want to convert this row to three rows and three columns:
1,2,3
4,5,6
7,8,9
Is there any formula to separate above row?
Bookmarks