Hi guys,

I believe I did not explain my situation well enough to be recommended a solution.

I would like to allocate an ID for each row of data.

However, the ID is stated only once, above the data (like a title).



I would need to perhaps count the number of cells within from "ASTRO" to the next "ASTRO" such that I can freshly add a new column and populate it with the respective ID.



Is there a code available for this?

Thank you very very much.