I can't guarantee this will work, since it sort of depends on the size of
your data.

In F1, type =A1&" "&B1&" "&C1&" "&D1&" "&E1
In F2, type =F1&" "&A2&" "&B2&" "&C2&" "&D2&" "&E2
Copy that formula down.

Hope this helps,
Jane

"McAndy" wrote:

How to make such a record:

a b1 c1 d1 e1 b2 c2 d2 e2 b3 c3 d3 e3


from this table:

a b1 c1 d1 e1
a b2 c2 d2 e2
a b3 c3 d3 e3


Tia,
Andrew