In google sheets I have listed my vertical axis with 10-bit code values. From 0 to 1023. I would like to assign 16-bit code values (from 0 to 65535) aside 10-bit code values. So instead of creating 65535 rows to distribute a perfect range from 0 to 65535, I would instead like to distribute 0 to 65535 across 10-bit code values (0 to 1023).

So in other words list a range from 0 (min) to 65535 (max) in 1023 increments. With the 1023 increment being 65535. The formula would have to be written for a single cell then I'd just copy it across the entire y-axis range to generate all the values between 0 and 65535 across all 10-bit increments.

How can I do this in google sheets?

CodePudding user response：

Use sequence(), like this:

=sequence(1024, 1, 0, 2^16 / 2^10)