It is Possible? Index Match - returning column header

[fidelito101]

Hello Team!

I have a table that contains Products and parts for manufacturing(sheet1)

Part Number	Part Name	TOYOTA 374F	TOYOTA 637F	NISSAN 1224	VOLVO 2650
HU294150-0400	CYLINDER	1		1
HU294150-0410	CYLINDER		1		1
HU294191-0100	CAMSHFT	1	1	1
HU294191-0070	CAMSHAT				1
HU294110-0380	BEARING COVER	1	1	1	1

<tbody>
</tbody>

And in Sheet2 I need a table like this below:

HU294150-0400	CYLINDER	TOYOTA 374F	NISSAN 1224
HU294150-0410	CYLINDER	TOYOTA 637F	VOLVO 2650
HU294191-0100	CAMSHFT	TOYOTA 374F	TOYOTA 637F	NISSAN 1224
HU294110-0380	BEARING COVER	TOYOTA 374F	TOYOTA637F	NISSAN	VOLVO2650
HU294191-0070	CAMSHAT	VOLVO 2650

<tbody>
</tbody>

And if is possible to avoid blank cells.
****** id="cke_pastebin" style="position: absolute; top: 274.4px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

CYLINDER

<tbody>
</tbody>

</body>

 

[AhoyNC]

Try:
This is an array formula that must be entered with CTRL-SHIFT-ENTER.
Drag formula down and across as needed.

Excel Workbook
	A	B	C	D	E
1	Part Number	Part Name
2	HU294191-0100	CAMSHAFT	Toyota 374	VOLVO 920
3	294096-0040	WASHER	Toyota 374	Lombardini 1800	VOLVO 920
4	HU294198-0010	O-RING	Toyota 374	VOLVO 920
Sheet2

Excel Workbook
	A	B	C	D	E
1	Part Number	Part Name	Toyota 374	Lombardini 1800	VOLVO 920
2	HU294191-0100	CAMSHAFT	1		1
3	294096-0040	WASHER	2	2	1
4	HU294198-0010	O-RING	3		2
Sheet1

 

[fidelito101]

Hi AhoyNC

This works like a charm!

Thanks, Thanks a lot for your help

 

[AhoyNC]

You're welcome. Thanks for the feedback.