Data is arranged as counts of a certain value - how to plot this?

[Ditlev]

Hey everyone.

I have the problem that the data I am plotting in Excel is arranged in the following way:

Rowid Count Value
1 2 1
2 3 4
.....
Is there a way to get excel to understand the structure of this data? So that it can interprete it as if all the measurement were written as below?
Rowid Value
1 1
2 1
3 4
4 4
5 4

I would like to make a scatter plot and find regression equation and R^2 value of this dataset.
Therefore, is it there anyway to plot the data in its present structure, or is there a smart way to change the structure of the data?
There are thousand of rows so manual alteration is not a possibility.
Thank you!
Best regards
Ditlev Reventlow

 

[Ditlev]

I hope it is clear that the arrangement now is that the "count" column is specifying how many times the "value" occurs in the dataset.