Hello,

I have a spreadsheet with two columns, with an ID number in the first column and the data point in the second column, and the different ID numbers are separated by a blank row.

For example:

ID Value
1 A
1 B
1 C

2 A
2 B

3 C



What I would like to do is transfer the data into multiple columns, with the first row as the ID number and each subsequent row containing the values for that ID.

For example:

ID 1 2 3
Value 1 A A A
Value 2 B B
Value 3 B


Any help at all would be greatly appreciated, thank you!!