How can I take data that is assembled in different rows and columns but refers to the same contact and have it automatically placed into columns with headings of name ....address....phone#....postal code.....city.... state

Is this possible if the data is in different rows and columns or does it have to be cut and paste all the way.

I have copied search results into excel and the data is there, but it is not in a column, it is in multiple columns in multiple rows and I need to configure it to columns under category headings.

thanks to anyone who can help.