In my attachment called "Raw" I have raw data and I wish to get a result which I mentioned as "Final output". I have around 5000 IDs, and the sequence is same for every ID as mentioned in attachment like ID 1 appears at Cell no. "A2" and ID 2 appears at "A7".....ID Nth appears after same no. of rows. Is there any way using formulas to get the final output. Appreciate any help. Thank you
Bookmarks