I have a column of data of 10000 rows in column A .
Need to adjust in column data A in column B and C as below.
Always same pattern
Column A Column B Column C
e.g 001 001 392690
392690
I have a column of data of 10000 rows in column A .
Need to adjust in column data A in column B and C as below.
Always same pattern
Column A Column B Column C
e.g 001 001 392690
392690
Please try at B1:C1
=INDEX($A:$A,(ROWS(B$1:B1)-1)*2+COLUMNS($B1:B1))
Good morning
in B1 drag to the right up to C1 and then down
=IFERROR(INDEX($A$1:$A$28,((ROW(A1)-1)*2)+COLUMN(A1)),"")
EDIT I'm sorry
I hadn't updated the page
Last edited by FioreMatto; 04-03-2019 at 05:01 AM.
Perfect
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks