Transponowanie

M

McAndy

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
 
J

Jane

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
 
M

McAndy

That is fine. Thanks.
One more thing.
How to put the data on separate cells (not single row in one cell)?:
ie:
| a |b1| c1| d1| e1| b2| c2| d2| e2| b3| c3| d3| e3|


Thank you,
Andrew
 
Top