How convert data to columns?

I have data in a columns (merge). I want filter to other columns.
Please, preview link attach.
Capture1.PNG
Helps.xlsx
Thank you very much.

I hate being so slow :D

=INDEX($B$5:$B$16; 9 - COLUMN() + (ROW()-5)*3;1)

was my try

Originally Posted by ramananhrm

Please try this function Across & down

=INDEX($B$5:$B$16,ROWS(F$5:F5)*3-(COLUMNS($F5:F5)-1))

Really, thank you very much.

I don't know is ......$B$16; ";" or $B$16, ",".... Not true. Can you upload your file try? Please.

Originally Posted by Evolta

I hate being so slow :D

=INDEX($B$5:$B$16; 9 - COLUMN() + (ROW()-5)*3;1)

was my try

I don't know is ......$B$16; ";" or $B$16, ",".... Not true. Can you upload your file try? Please.

Originally Posted by Evolta

I hate being so slow :D

=INDEX($B$5:$B$16; 9 - COLUMN() + (ROW()-5)*3;1)

was my try

I don't know is ......$B$16; ";" or $B$16, ",".... Not true. Can you upload your file try? Please.

Ye it should be: (my separating symbol is ";", most others seem to have ",")

=INDEX($B$5:$B$16, 9 - COLUMN() + (ROW()-5)*3,1)

I don't have the file anymore, but you can just copy past this the same way ramananhrm said.
If you want it in another place, change the 9 and the 5

I want know, understand more. , please help me write get 1A (colum F) and LT10 (colum G) Evolta? Thank you.

Open ramananhrm file.
=INDEX($B$5:$B$16,ROWS(F$5:F5)*3-(COLUMNS($F5:F5)-1))

Index(range,row,column)
range = $B$5:$B$16 ==> here is the information you have

row = ROWS(F$5:F5)*3-(COLUMNS($F5:F5)-1
==> Rows(F$5:F5)*3 will return 1*3 = 3,
==> -(Columns($F5:F5)-1) will return -1-(-1)= -1 + 1 = 0
==> so in total you get Row 3 + 0 = Row 3

column = nothing ==> since there is just 1 column and 1 is default

So then you get the 3th row and the 1st column from your selection $B$5:$B$16