Forum Discussion
NUMBERS IN COLUMNS TO
NUMBERS IN COLUMNS In one sheet I have many groups (about 300 groups) of 5 numbers in column. These numbers change every 5 minutes. I need to convert these numbers in another sheet in many rows of...
As variant that could be
with formula
=INDEX($B:$B,(ROW()-ROW($D$7))*5+ROW($B$2)+COLUMN()-COLUMN($D$7),1)dragged within target range.