pls help

[mbge7clt]

hi,
pls refer to attached excel. col a is index, col b is binaries, col c is hex conversion from col b by grouping 4 rows. e1 to e7 is concatenation of col c in group of 32. in this example, there are 572 rows which if divided by 128 (32*4) will result into 4.46 lines which round up to 5 lines. extra zeroes are used to represent the modulus (refer to e7).
my question is how to to automate the process instead of writing the concatenation formula manually for 32 rows.
pls note 572 rows is a variable as it could be other number of rows.



thanks
johnny

[pbengtss]

Here's a quick start, click the "Run macro" to test.

The extra zeroes works only if you copy down column C, scroll down and you'll see what I mean.


Is this what you were looking for?