Hi,

I have cut and pasted a table from an online database into a spreadsheet.

It has pasted into one column.

How can I format the data so that each entry appears in one row across
various columns.

Currently I am transposing each entry individually by paste special.

Help! I have 300 to do!