I have one column with 806 rows.
One cell of data in each row.
I want to the split out the rows to different columns with 30 in each column.
Is it possible to do this without having to cut and paste 30 cells at a time?
I have one column with 806 rows.
One cell of data in each row.
I want to the split out the rows to different columns with 30 in each column.
Is it possible to do this without having to cut and paste 30 cells at a time?
have you looked at the built in functionality of Text to Columns found on the Data Tab of the Ribbon?
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I'm familiar with Text to Columns.
I'm not trying to split the contents of the cells into separate columns.
I'm trying to move the first 30 cells in the column to a separate column.
Then move the next 30 cells to a different column.
Example 1.JPG
a b c d e f g 2 1 1 31 61c2: =index($a$2:$a$997, rows($c$2:c2) + 30 * columns($c$2:c2) - 30) 3 2 2 32 62 4 3 3 33 63 5 4 4 34 64 6 5 5 35 65 7 6 6 36 66 8 7 7 37 67 9 8 8 38 68 10 9 9 39 69 11 10 10 40 70 12 11 11 41 71 13 12 12 42 72 14 13 13 43 73 15 14 14 44 74 16 15 15 45 75 17 16 16 46 76 18 17 17 47 77
Entia non sunt multiplicanda sine necessitate
AWESOME!!!! I really appreciate it. That just saved me soooooooo much time. ^5
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks