In the following example, there is an ID column with group information.

Highlight column B and choose Analysis: Mathematics: Normalize Columns… menu

Specify Column A (ID) as Group column and choose Normalize Methods as Divided by Max.

See the output column C. Origin finds the max B within each group defined by A and divides each value in that group with the group max.