Split 2 columns into smaller equal value columns.

[digimob]

Hi Guys,
I am new to this and hope someone can help with this:
I have 75 batteries, each has an ID no. In column A and a value in column B.

Ihave 2 columns A and B
A is an ID number, 1-75
B is a numerical value ranging from 1480 to 2300

I need to split this data into 15 pairs of columns, so 30 in total.
I want the value of the 15 value columns to be as equal as possible, with the ID column alongside

 

[Peter_SSs]

Duplicate to Split 2 columns into smaller equal value columns.

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.