How to calculate percentage in Excel

[davidovich1]

Hello guys,
Is there an easy way to calculate these data?
I would like to turn this:

to this:

Thank you in advance

 

[Trevor_S]

Yes, if you're happy for the "result" to be in a different row from the original data. From the picture, your original data appears to in row 31 and the result in row 13. So the formula in A13 is
=A31&" ("&TEXT((A31/SUM(31:31)),"#.#%")&")"