Hi,
I need to basically have each number in my column (B) be split apart by the same number of blank cells (Column F). Preferred if it would also copy each number into those blank cells (Column H). Thanks!
ExamplePic1.PNG
Hi,
I need to basically have each number in my column (B) be split apart by the same number of blank cells (Column F). Preferred if it would also copy each number into those blank cells (Column H). Thanks!
ExamplePic1.PNG
Last edited by blue84rain; 11-20-2014 at 03:34 PM.
Try these two
=IFERROR(IF(MOD(ROWS(A$1:A3),3)+1=1,INDEX($B$2:$B$4,INT(ROWS(A$1:A3)/3)),""),"")
and
=IFERROR(INDEX($B$2:$B$4,INT(ROWS(A$1:A3)/3)),"")
Row\Col B C D E 2 111 111 111 3 112 111 4 113 111 5 112 112 6 112 7 112 8 113 113 9 113 10 113
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hey Alkey,
Thanks for the help! I was able to create a pivot table to copy the data out how I wanted. I couldn't get the formula to work for me.
You could try simply to copy and paste these formulas. Just make sure that
111
112
113
is in B2:B4
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks