User Profile
samiuns
Copper Contributor
Joined 11 months ago
User Widgets
Recent Discussions
Split one row 16 columnto 4 row 4 columns
Hi, I have a little bit problem for copying and pasting formula. Here an example: In sheet A, for one row data and 16 column in the same row, I want to use equal (=) formula into a 4 rows with 4 columns in the sheet B. From picture above, I have row number 2, and column F through U (sheet A) In first row of sheet B, I want to use that data but only column F to I. The next row, I want to use data from column J to M, then N to Q and R to U. So now I have one 4 rows of data and column which is a split for one row from sheet A. How can I copy and paste 4 rows, with a formula which use a same row number in the formula, and only increasing by 1 after 4 rows? Thanks.
