Possible formula to assist with this?

[moonbuck]

I need to have a list "flattened" <technical term?

Part IDS is column B contains different suppliers for parts in column A. Multiple suppliers need to be spread out into individual columns so there is a single part number in column A.

How it looks

ID	VENDOR_ID	PART_NO	COST
01011 68 74 OE	PPI	1011	5.23
01011 68 74 OE	IMC	1011	905.77
01011 68 74 OE	HOUSEGHIA	1011	1.1

<tbody>
</tbody>

How I need it to look

ID	Vendor_1 Name	Vendor_1 Prt#	Vendor_1 Cost	Vendor_2 Name	Vendor_2 Prt#	Vendor_2 Cost	Vendor_3 Name	Vendor_3 Prt#	Vendor_3 Cost
01011 68 74 OE	PPI	1011	5.23	IMC	1011	905.77	HOUSEGHIA	1011	1.1

<tbody>
</tbody>

I appreciate any assistance. I am rather new to this.
Thanks</technical>

 

[PCRIDE]

You may want to try recording a macro. I don’t really see a different in your examples

 

[Rick Rothstein]

Part IDS is column B contains different suppliers for parts in column A. Multiple suppliers need to be spread out into individual columns so there is a single part number in column A.

Is your data sorted by IDs first and then Part_No second?

 

[moonbuck]

You may want to try recording a macro. I don’t really see a different in your examples

I am not familiar with how to record a macro.

 

[moonbuck]

it is just sorted by ID. I hope I explained the issue correctly. I find that it is sometimes difficult to explain what I am trying to accomplish when it comes to excel.
I was unsure how to get the example to show up visually as a spreadsheet instead if just text.

to clarify, "VENDOR_ID" has 3 options for the same "ID"
I need to show a single row for the "ID" and have the 3 different "VENDOR_ID"s each in their own columns. This applies to the "PART_NO" and "COST" accordingly.

It seems like there should be a way break these out with a formula.

Thanks

 

[moonbuck]

Is your data sorted by IDs first and then Part_No second?

it is just sorted by ID. I hope I explained the issue correctly. I find that it is sometimes difficult to explain what I am trying to accomplish when it comes to excel.
I was unsure how to get the example to show up visually as a spreadsheet instead if just text.


to clarify, "VENDOR_ID" has 3 options for the same "ID"
I need to show a single row for the "ID" and have the 3 different "VENDOR_ID"s each in their own columns. This applies to the "PART_NO" and "COST" accordingly.


It seems like there should be a way break these out with a formula.


Thanks