FreakyGirl
Member
hello
i have a list of 575 names in A column sorted in ABC order. i took that list & made it into 5 columns reading left to right - not up & down using the formula
Now i would like to have it start a new row when a new letter starts instead of A & B or E & F etc. being on the same row.
For example, there are 24 names that start with "_". there are 20 names that start with "A". the 25th cell of the 5 columns should remain blank because theres not another "_" name to fill it. instead the list should continue on the next row or even skips a row & then start letter "A".
i have made helper columns but none of the formulas i try with IF or OFFSET seem to work correctly. I have also tried to play with the formula i use to create the columns but that doesnt bring the correct results.
this list changes monthly & it just seems there would be an easier way to do it.
i have included a workbook & appreciate any input. perhaps im going about this the wrong way. i have also shown what the desired result should look like.
thanks & have a great day all!
FreakyGirl
i have a list of 575 names in A column sorted in ABC order. i took that list & made it into 5 columns reading left to right - not up & down using the formula
Code:
=INDIRECT("R" & (ROW()-1)*5+MOD(COLUMN()-1,5)+1 & "C1", FALSE)For example, there are 24 names that start with "_". there are 20 names that start with "A". the 25th cell of the 5 columns should remain blank because theres not another "_" name to fill it. instead the list should continue on the next row or even skips a row & then start letter "A".
i have made helper columns but none of the formulas i try with IF or OFFSET seem to work correctly. I have also tried to play with the formula i use to create the columns but that doesnt bring the correct results.
this list changes monthly & it just seems there would be an easier way to do it.
i have included a workbook & appreciate any input. perhaps im going about this the wrong way. i have also shown what the desired result should look like.
thanks & have a great day all!
FreakyGirl