bastiaan_vg
New Member
- Joined
- Apr 17, 2007
- Messages
- 15
Hi There,
We have an Excel list with data row and column wise like:
Column A . . . Column B . . . . . Column C
Code1. . . . . .Text1_C1 . . . . . . Adon1_C1
. . . . . . . . . . . . . . . . . . . . . . .Adon2_C1
Code2 . . . . . .Text1_C2 . . . . . .Adon1_C2
. . . . . . . . . . Text2_C2 . . . . . .Adon2_C2
. . . . . . . . . . Text3_C2
We want to transpose this into the following:
Column A . . . . . Column B
Code1 . . . . . . . . List:
. . . . . . . . . . . . Text1_C1
. . . . . . . . . . . . Documentation:
. . . . . . . . . . . . Adon1_C1
. . . . . . . . . . . . Adon2_C1
Code2 . . . . . . . . List:
. . . . . . . . . . . . Text1_C2
. . . . . . . . . . . . Text2_C2
. . . . . . . . . . . . Text3_C2
. . . . . . . . . . . . Documentation:
. . . . . . . . . . . . Adon1_C2
. . . . . . . . . . . . Adon2_C2
Is there a formula that can achieve this. If there is data in column B, then it must start with "List" in the new situation. Same as for column C, we want to start with "Documentation".
We have a big list and we do not know for column B and C how many entries there are, there could be none, 1, 2 or even more entries.
Thanks for any help, effort,
Bastiaan
We have an Excel list with data row and column wise like:
Column A . . . Column B . . . . . Column C
Code1. . . . . .Text1_C1 . . . . . . Adon1_C1
. . . . . . . . . . . . . . . . . . . . . . .Adon2_C1
Code2 . . . . . .Text1_C2 . . . . . .Adon1_C2
. . . . . . . . . . Text2_C2 . . . . . .Adon2_C2
. . . . . . . . . . Text3_C2
We want to transpose this into the following:
Column A . . . . . Column B
Code1 . . . . . . . . List:
. . . . . . . . . . . . Text1_C1
. . . . . . . . . . . . Documentation:
. . . . . . . . . . . . Adon1_C1
. . . . . . . . . . . . Adon2_C1
Code2 . . . . . . . . List:
. . . . . . . . . . . . Text1_C2
. . . . . . . . . . . . Text2_C2
. . . . . . . . . . . . Text3_C2
. . . . . . . . . . . . Documentation:
. . . . . . . . . . . . Adon1_C2
. . . . . . . . . . . . Adon2_C2
Is there a formula that can achieve this. If there is data in column B, then it must start with "List" in the new situation. Same as for column C, we want to start with "Documentation".
We have a big list and we do not know for column B and C how many entries there are, there could be none, 1, 2 or even more entries.
Thanks for any help, effort,
Bastiaan