organize column's cells with content into new column that excludes empty cells?

**jasoncovone** · 12-23-2018, 06:37 PM

Hey, I would like to organize a column where only some of the cells in said column have text, into an adjacent column that excludes the empty cells. Is there a function or trick to do this? I attached an example of what I mean.

Thanks in advance!

**FlameRetired** · 12-23-2018, 08:31 PM

Hello jasoncovone. Welcome to the forum.

Try this:

	A	B	C
1	bob	bob	=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$1:$A$11)/($A$1:$A$11<>""),ROWS(A$1:A1))),"")
2		mark
3		john
4	mark	peter
5
6	john
7
8
9
10
11	peter

**jasoncovone** · 12-24-2018, 12:50 AM

It worked perfectly! Thank you for the welcome and for the help!

Jason

**FlameRetired** · 12-25-2018, 02:34 AM

You are welcome. Glad to help.

Thank you for the feedback and marking your thread Solved?

organize column's cells with content into new column that excludes empty cells?

LinkBack

Thread Tools

Rate This Thread

Display

organize column's cells with content into new column that excludes empty cells?

Re: organize column's cells with content into new column that excludes empty cells?

Re: organize column's cells with content into new column that excludes empty cells?

Re: organize column's cells with content into new column that excludes empty cells?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] 8 Columns with empty cells -> 1 Column without empty cells -> Problem: 1st value ignored

Toggle Button to Filter Empty cells in one column, and cell value in other column

[SOLVED] Copy all cells in column that contain data & paste to first empty row of another column.

Top 5 formula that returns the content (text) of cell that EXCLUDES filtered/hidden cells

Insert data from one column into the empty cells of an adjacent column

Formula that excludes cells if next column reads "away"

Copy a formula to cells in column A which don't have an empty cell in column B

Bookmarks

Bookmarks

Posting Permissions