Formula for data cleansing - Pls Help

I have an excel sheet that contains registrations list of our event. Depending upon the country you are registering from the length of the form gets adjusted. Bcs of this reason when I created a list of final registration, data seems to be jumbled up a bit.

For eg: C stands for Column and R stands for Rows... in C1, R1-5 is filled with email addresses. But from 6 - 7, it’s first name, 8-11 is last name and soon for other data sets. There are at least 20 Cs and on all Cs data is arranged in this manner but they are not equally sequenced in rows. I mean to say that in C2, R1-5 is country details and 6-7 is email and 8-11 is contact phone...My requirement is to get only emails in one single column C1, first names in C2, phone in C3, for all registrants... any formula that u can recommend wud be really helpful....

I'm not sure I fully understand. First your C's and R's don't seem to match the spreadsheet. It probably would have been better to just reference the Excel Cells themselves (like range "A5:A10", etc.)

But based on your sample data, I'm assuming several things. First, is your input data for email always going to have the term "Email" in it? Just like "Phone", etc. If the different columns always have a specific (and unique) word in them, because you are on 365, you can use the XLOOKUP function. For instance, to get the email cell, you could use this formula:

=XLOOKUP("Email*",$A5:$F5,$A5:$F5,"Not found",2,1)

And phone like this:

=XLOOKUP("Phone*",$A5:$F5,$A5:$F5,"Not found",2,1)

etc. I've attached an updated workbook. I may have really missed your requirement so sorry if that is so, but given this, maybe you could re-explain your issue if needed.