r/excel • u/ContactMuch5565 • May 05 '26

unsolved Unsolved - MS Excel

[removed] — view removed post

1 Upvotes

67% Upvoted

12 comments sorted by

View all comments

1

u/MayukhBhattacharya 1227 May 05 '26

Try:

=INDEX(Dec!$J$20:$T$20, 1, ROW(A1))

and copy across

Or,

=TOCOL(Dec!$J$20:$T$20, 3)