Mutliple Group Cols into One Group Cols

[ratcat]

G'day Everyboby,

Cross-link post: Pull selected fields from multiple tabs into one

There has been a further request on this challenge which has yet, I can not for fill.

On the "Customer Information" there is 5 main heading (eg porduct 1) with 3 sub heading (eg Part #).

What is the following step to get the 5 main heading into one with the sub heading to follow.

Thanks

[vane0326]

Maybe...

Input formula in cell B9 and copy down.


=SMALL('*'!$B$2:$B$11,ROWS($B$9:B9))



Hope it helps!

[Rockter]

Hello,

I tried that formula but it went over the top of the =IF(Database)... formula and displayed different #'s. Any other ideas?

Zack

[ratcat]

G'day Everybody,

After researching, the result is that there are countless add-ins out there some free and not. This is the way I see around this problem.

Just go to your search engine (eg Google) and place keywords like excel mutliple column into one column.

Hope that helps


Cheers

ratcat