Help with repeated patterns in one column

[kiwidude]

Hey Folks,

I am trying to sort out some data which looks like this (example of one set):

ColA Col B
0 3240
1 89201
2 329832
3 20
4 893701
5 122.33

So column A keeps repeating (actually has 500 (0-500) values) column B changes, there are around 600 sets of A and B. So is it possible to extract each set in excel somehow.

Any help would be useful, actual file is too large to upload, here is a link I uploaded the file to.

https://www.transferbigfiles.com/c83...UadzHiffRg4gg2

Thank you.

[dilipandey]

Hi Kiwidude,

Welcome to the forum.

What is the output you are expecting from the data set you have shown...?
I guess sumproduct function can help here... Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[kiwidude]

Thank you, unfortunately I am a basic excel user and hence I was advised by a colleague to come here for some help.
I attach two figures as example screenshots of what I want to achieve (without copying and pasting) as there are more than 600 records.
Thank you.

What I have.png
What I have

What I want.png
What I want

[arlu1201]

Its better if you attach a sample excel file instead of a png. We can save time in giving you the solution instead of re-creating the png to a excel file.