Splitting data in one column into rows

Hello,
I have a situation where as all of the data from a survey was down loaded into one column. Each block of 10 rows represent one response. I need to have each response be reflected in a row.
This is what I have.

COLUMN A
- <form1>
  <DutyStatus>
<Building>
  <Reason />
  <Other />
  <Cardboard>
  <Metalcans>
  <Plastics>
  <Paper>
  </form1>
<form1>
  <DutyStatus>
  <Building>
<Reason />
  <Other />
  <Cardboard>
  <Metalcans>
  <Plastics>
  <Paper>
  </form1>
<form1>
  <DutyStatus>
<Building>
<Reason>
<Other />
  <Cardboard>
  <Metalcans>
  <Plastics>
  <Paper>
  </form1>
- <form1>

What I need is for to look like
A B C D E G H I
<DutyStatus> <Building> <Reason /> <Other /> <Cardboard> <Metalcans> <Plastics> <Paper>   <DutyStatus> <Building> <Reason /> <Other /> <Cardboard> <Metalcans> <Plastics> <Paper>   <DutyStatus> <Building> <Reason> <Other /> <Cardboard> <Metalcans> <Plastics> <Paper>

Thank You