How can I set same recordID to data based on order of the record?

[Tulkas]

I have set of data with some random numbers.

And I need to group them by their order of appearance

For example

 I need to make above data into like below.

 like first 7 rows should have recordID 1, next 3 row should have recordID 2 and so on.

I tried to group them but can't find right tools to do so because other datas have nothing in common for grouping.

Is there any tools or formula that I can use to prepare my data?

[ericsundby]

I just need a little bit of clarification on what you're trying to accomplish here. When you say you need to group them by their order of appearance, do you mean by their value? So if there were a set of numbers in columns B-C (data1, data2, data3) that ranged from 1-10, do you want instances of the same value across columns B-C to be grouped? Instead of denoting the values as "random num" in the example data, it might be easier for me to fully understand the requirements if you replaced them with real values. 

[sparksun · Accepted solution]

If your data is small,you can use this solution.

[Tulkas]

I have two set of data.

One is data header made of 8 rows which has datas such as date of record, and has number of records that each data header contains.

Other set of data is bunch of data that needs to be sorted into data header.

My goal is to seperate second dataset into 8 groups by record numbers and join it with first dataset.

First 3045 data of dataset 2 should go to data header number 1, and next 578 datas should go to deta header number 2 and so on.

I'm sorry I can't upload original data because it contains some personal datas

first dataset(data header)

second dataset(actual datas)

[Tulkas]

Thanks I totally forgot about select records function.

It helped a lot.