#1
|
|||
|
|||
Consolidate columns into one continuous column
I'd like to know if i can consolidate all of these columns into one continuous column.
Thanks rooly |
#2
|
|||
|
|||
Maybe like the attached.
|
#3
|
|||
|
|||
thanks....
Many thanks to you, What do i change in formula to continue the formula if i want more than ten lines in each column. ?
|
#4
|
|||
|
|||
See comments in the attached.
|
#5
|
||||
|
||||
@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
__________________
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 |
#6
|
|||
|
|||
..
Thanks again . But it is limited up to 60 rows , If i add more than that it no longer shows them ....
|
#7
|
|||
|
|||
No it is not limited to 60 rows.
As Pecoflyer point out to you, please post a sheet instead of a picture. |
#8
|
|||
|
|||
Have you tried just to enter something in row 18 and see what happens?
|
#9
|
|||
|
|||
...
Yes i have added more rows and it works, but does not continue after row no. 61
please note the image i`v attached |
#10
|
|||
|
|||
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. |
#11
|
|||
|
|||
..
OK Thanks..
I`m uploading my file and also yours. |
#12
|
|||
|
|||
Did you try copying the formula further down?
(To me your column order is in reverse). |
#13
|
|||
|
|||
Thanks again for your help. Yes i tried and it solves the problem.
|
#14
|
||||
|
||||
As you don't seem concerned about my post #5, I will close this thread
__________________
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Continuous Paragraph across two columns vs Parallel Column Paragraph | Pinesh | Word | 2 | 03-09-2018 04:24 PM |
Don't Balance Columns for Continuous Section Starts | titani2 | Word | 1 | 01-25-2015 01:11 PM |
Continuous section break and column changes | Jim B | Word | 3 | 11-27-2012 02:25 PM |
Columns. How to move the left column so it's to the right of the 'right' column ? | Vit | Word | 9 | 11-21-2012 12:57 PM |
How to expand one column into two columns? | Jamal NUMAN | Excel | 1 | 01-12-2011 07:59 PM |