I'd like to know if i can consolidate all of these columns into one continuous column.

Thanks
rooly

Attached Images

	1.JPG (59.9 KB, 24 views)
	2.JPG (83.1 KB, 23 views)

Maybe like the attached.

Attached Files

Columns.xlsx (9.7 KB, 10 views)

Many thanks to you, What do i change in formula to continue the formula if i want more than ten lines in each column. ?

See comments in the attached.

Attached Files

Columns_2.xlsx (11.6 KB, 10 views)

@rooly
It was be nice of you at least acknowledging answers to https://www.msofficeforums.com/excel...nce-excel.html

In the future please post a sheet instead of pictures. It's easier to work with

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks again . But it is limited up to 60 rows , If i add more than that it no longer shows them ....

Attached Images

4.jpg (38.4 KB, 20 views)

No it is not limited to 60 rows.

As Pecoflyer point out to you, please post a sheet instead of a picture.

Have you tried just to enter something in row 18 and see what happens?

Yes i have added more rows and it works, but does not continue after row no. 61
please note the image i`v attached

Attached Images

5.JPG (54.0 KB, 19 views)

For another time, images aren't of much help as pointed out earlier. Please upload file instead.

Copy down the formula below row 60 as far as needed.

OK Thanks..
I`m uploading my file and also yours.

Attached Files

	H.xlsx (82.9 KB, 10 views)
	Columns_2.xlsx (13.3 KB, 8 views)

Did you try copying the formula further down?

(To me your column order is in reverse).

Thanks again for your help. Yes i tried and it solves the problem.

As you don't seem concerned about my post #5, I will close this thread

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post