Adding data to columns

[astridcita]

Hi,
I have a question, I have an excel (2010) with name and I withdraw data from another sheet under each name, this is the formula I use

=IF('Tasks by Group'!$B:$B = "Fred",'Tasks by Group'!$A:$A,"")

The problem is that I don’t want empty cells in between the data.

Right now I have

Fred	Maria	Paulina
Banners		Banners
Search	Promote
		Search
Banners	Promote

<tbody>
</tbody>

Here is the result I want.

Fred	Maria	Paulina
Banners	Promote	Banners
Search	Promote	Search
Banners

<tbody>
</tbody>

How do I do that?

thanks!!!!

 

[Akashwani]

Hi,

If I understand you correctly, does this work for you?....

Sample data...

Excel Workbook
	A	B	C
1	Data1	Data2
2	Banners	Fred
3	Banners	Paulina
4	Banners	Fred
5	Black	Bob
6	Blue	Tim
7	Brown	Ben
8	Pink	Bill
9	Promote	Maria
10	Promote	Maria
11	Red	Tom
12	Search	Fred
13	Search	Paulina
14	Yellow	Tod
15
Tasks by Group

Example results....

Excel Workbook
	A	B	C	D
1	Fred	Maria	Paulina
2	Banners	Promote	Banners
3	Banners	Promote	Search
4	Search
5
Results

The formula in A2 needs entering with ctrl shift enter NOT just enter, it can then be copied across and down.
You can change the cell references to suit your layout.

I hope that helps.

Ak

 

[astridcita]

thanks, i will look into it and try to understand what you did

 

[Akashwani]

Hi,

This will probably help you to understand aspects of the formula...

Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods - YouTube

Mike has some excellent videos on Extracting data as well as loads of other very helpful Excel videos.

Ak

 

[astridcita]

Perfect thanks!
array is a new world for me on excel

 

[Akashwani]

Hi,

I'm pleased it helps and thanks for the feedback.

Ak