Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Transponowanie
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 Użytkownik "Jane" napisał w wiadomo¶ci ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|