Nov 18 2021 01:11 PM
Nov 19 2021 12:45 PM
The following suggestion ... as far as I could understand your concern.
In a Sheet1, write in cell A1:
= INDEX (Table1! A: A, (ROW (A1) +1) / 2)
and copy that down as far as necessary.
In B1 then:
= INDEX (Table1! B: B, (ROW (A1) +1) / 2)
and in C1:
= INDEX (Table1! C: C, (ROW (A1) +1) / 2)
If you allow, for the next time you want to ask a question (which will be very welcome) I would recommend you to insert a file (without sensitive data), as well as Excel version and operating system. In this way, you can come up with a tailor-made solution proposal / offer much more precisely and more quickly.
Thank you for your understanding and patience.
I also wish you success with Excel.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Nov 19 2021 12:49 PM - edited Nov 19 2021 12:49 PM
Same basic method as Niko, just with changed absolute/relative references and used offset to make it one easily draggable formula. Try this formula in a separate sheet A1. (assuming your data is in Sheet1 and starts in A1).
Just drag right for as many columns as you need to copy and then drag down.