I have a table of 4 columns and 20 rows. Every cell in that table is considered as label. in an other cells beside this table i have some cells with data. In the first cell i enter the number of cells of the table where all data of of the other cells will be displayed. example i put 3 in K21 and it will display concatenate all info of the other cells in 3 cells of the table. My problem is that if I change the value of K21 and data of input cells for example 5 in the table it will display 5 times in the cells after the 3 cells.Another problem is that when it arrives in column1 to Row20 it has to go to row1 column2.
For labels:
In column1 cells i put this formula until ROW20
=IF(ROW()<=$K$21,CONCATENATE($J$22,$K$22,CHAR(10),$J$23,$K$23,$J$24,$K$24,CHAR(10),$J$25,$K$25,$J$26,$K$26,$J$27,$K$27,$L$27,CHAR(10),$J$28,$K$28,$L$28,$J$29,$K$29),"")
In column2 cells i put this formula until ROW20
=IF(ROW()+20<=$K$21,CONCATENATE($J$22,$K$22,CHAR(10),$J$23,$K$23,$J$24,$K$24,CHAR(10),$J$25,$K$25,$J$26,$K$26,$J$27,$K$27,$L$27,CHAR(10),$J$28,$K$28,$L$28,$J$29,$K$29),"")
In column3 cells i put this formula until ROW20
=IF(ROW()+40<=$K$21,CONCATENATE($J$22,$K$22,CHAR(10),$J$23,$K$23,$J$24,$K$24,CHAR(10),$J$25,$K$25,$J$26,$K$26,$J$27,$K$27,$L$27,CHAR(10),$J$28,$K$28,$L$28,$J$29,$K$29),"")
In column4 cells i put this formula until ROW20
=IF(ROW()+60<=$K$21,CONCATENATE($J$22,$K$22,CHAR(10),$J$23,$K$23,$J$24,$K$24,CHAR(10),$J$25,$K$25,$J$26,$K$26,$J$27,$K$27,$L$27,CHAR(10),$J$28,$K$28,$L$28,$J$29,$K$29),"")
Thank you very if someone can help me
Could you please provide an anonymized example file, including your formulas. showing what you get and showing what you like to get. Of course you can use any fake data and just as much data to show your problem.