Hello
I have files that I have to turn like for example the file looks like that
and i need it to look like this (this is a fake data)
I have used this formula
=LOOKUP(REPT(“Z”,255),CHOOSE({1;2},"",INDEX($A$2:$A$20000,MATCH(TRUE,INDEX(ISNA(MATCH($A$2:$A$20000,$K$1:$K1,0)),0),0))))
and then
=IF(G2="","",IFERROR(INDEX($B$1:$F$3435,SMALL(INDEX(IF($A$2:$A$3435=$G2,ROW($A$2:$A$3435),""),,1),INT((COLUMNS($H:H)-1)/5)+1),MOD(COLUMNS($H:H)-1,5)+1),""))
But now the lookup function is not working, is always says there is error in the formual. But it worked when I did this like 8 months ago:/
Can you help me? If you have another idea to do this that works, I have been googling but can't find any
I have files that I have to turn like for example the file looks like that
col1 | col2 | col3 |
100 | 789 | ckdsjfkd |
100 | 889 | adsfdsf |
100 | 934 | sjfkdsajf |
101 | 897 | sdfdisjf |
101 | 394 | sldfkdl |
and i need it to look like this (this is a fake data)
col1 | col2 | col3 | col4 | col5 | col6 | col7 |
100 | 789 | ckdsjfkd | 889 | adsfdsf | 934 | sjfkdsajf |
101 | 897 | sdfdisjf | 394 | sldfkdl |
I have used this formula
=LOOKUP(REPT(“Z”,255),CHOOSE({1;2},"",INDEX($A$2:$A$20000,MATCH(TRUE,INDEX(ISNA(MATCH($A$2:$A$20000,$K$1:$K1,0)),0),0))))
and then
=IF(G2="","",IFERROR(INDEX($B$1:$F$3435,SMALL(INDEX(IF($A$2:$A$3435=$G2,ROW($A$2:$A$3435),""),,1),INT((COLUMNS($H:H)-1)/5)+1),MOD(COLUMNS($H:H)-1,5)+1),""))
But now the lookup function is not working, is always says there is error in the formual. But it worked when I did this like 8 months ago:/
Can you help me? If you have another idea to do this that works, I have been googling but can't find any