Consolidate multiple columns and rows into one Column

**jewels3059** · 05-08-2013, 08:44 PM

Hello,

I have used this site many times but have never posted. I cant seem to find the answer for this and I am sure it is something very simple.

I have 9 columns with over 1000 rows, some cells have number in them and some dont. I need to have 1 column that has all the numbers instead of 9 different columns. I am attaching an example because its hard to explain what I am trying to do without seeing it.

If you look at the attached A2:J2 you will see A2 and G2 have the same number, I want that number to be displayed in column K. If a number is in a column and row it is the same number so I only need it once.

Thanks in advance!

**venkat1926** · 05-09-2013, 01:55 AM

how to explai is take 3 or 4 rows and explain and show how the result should be

**jewels3059** · 05-09-2013, 11:12 AM

Hello,

I am attaching a new document with the "RESULT" in column K. All I want to do is have a formula that will get the numbers from the row and add it to column K, if there is not a number then is would be blank. If there are numbers in a row, they are all the same, so I want them in one column.