CODEWITHSUNDEEP
excel
Moe.A
Moe.A

Reputation: 81

How to assign column values to grid in Excel?

I have 36 data points I want to assign to 6X6 grid as per the attached image.

Is there a way to tell Excel to take the point from the column to its location on the grid?

picture

Upvotes: 0

Views: 265

Answers (1)

user4039065
user4039065

Reputation:

Try this standard formula in G3.

=INDEX($E$2:$E$37, ABS(ISODD(ROW(1:1))*7-COLUMN(A:A))+(ROW(1:1)-1)*6)

Fill right and down.

        index_offset_snake

Upvotes: 1

Related Questions