How to show Cells in Separate Columns

[desibouy]

Hello,

As per Title, this is what I'm trying to achieve, I've tried Pivot Table and also within the CRM/ERP system we currently use but currently it's a limitation i.e. not available.

If I extract the CSV file this is what I get (Please Note: Right now my Concats only working with Vendor 2 not Vendor 3, 4, 5 etc)

MultiVendorMultiImageDATAFEEDMRResults509.xls
	A	B	C	D	E	F	G	H
1	Internal ID	SKU	Name	Vendor Name	Vendor Price	Online Price	Purchase Price	Concated Field
2	32877	DYN3692/CS	100% Cotton Non Sterile Stockinette	Dynarex	23.00	53.99	27.06	Dynarex, United Ostomy & Surgical Supplies
3	8841	DYN3552/CS	Paper Surgical Tape	United Ostomy & Surgical Supplies	49.38	84.99	51.45	United Ostomy & Surgical Supplies, Dynarex, Ford Medical
4	8841	DYN3552/CS	Paper Surgical Tape	Dynarex	51.45	84.99	51.45	United Ostomy & Surgical Supplies, Dynarex, Ford Medical
5	32877	DYN3692/CS	100% Cotton Non Sterile Stockinette	United Ostomy & Surgical Supplies	27.06	53.99	27.06	Dynarex, United Ostomy & Surgical Supplies
6	8841	DYN3552/CS	Paper Surgical Tape	Ford Medical	48.3	84.99	51.45	United Ostomy & Surgical Supplies, Ford Medical, Dynarex
MultiVendorMultiImageDATAFEEDM

This is what I'm trying to achieve.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	Internal ID	SKU	Name	Vendor Name 1	Vendor Price 1	Vendor Name 2	Vendor Price 2	Vendor Name 3	Vendor Price 3	Vendor Name 4	Vendor Price 4	Vendor Name 5	Vendor Price 5	Vendor Name 6	Vendor Price 6	Vendor Name 7	Vendor Price 7	Vendor Name 8	Vendor Price 8	Vendor Name 9	Vendor Price 9	Vendor Name 10	Vendor Price 10	Online Price	Purchase Price
2	32877	DYN3692/CS	100% Cotton Non Sterile Stockinette	Dynarex	23.00	United Ostomy & Surgical Supplies	27.06																	53.99	27.06
3	8841	DYN3552/CS	Paper Surgical Tape	United Ostomy & Surgical Supplies	49.38	Dynarex	51.45	Ford Medical	48.3															84.99	51.45
Sheet1

As I said above, I'm unable to get this working on the ERP/CRM system so thought If I can concat within the system and export it then a Pivot Table would work but I can't get it work I'm no expert nor with Excel. I'm like Basic at best also I want to note, I don't use Power Tools or whatever it's called.

oh another thing, right now my above example doesn't show Vendor Prices except for the first one, I'm trying to work on this to bring in all the Vendor Prices using Concat.

I hope I've provided enough information.

Any help appreciated.

Thanks

- Edit
Wait, can this be achieved using Text to Columns LOL? I have like 6000 Row of Data, not sure if that'll work

 

[mamady]

Hi Dear, your MS Office version is not updated in your profile, but this can be easily done using Power Query Editor in Excel

The following youtube tutorial will explain the steps to be followed

Best Regards
M.Yusuf

 

[desibouy]

Hi Dear, your MS Office version is not updated in your profile, but this can be easily done using Power Query Editor in Excel

The following youtube tutorial will explain the steps to be followed

Best Regards
M.Yusuf

Thank you That actually helped me. Still a long way to go

I'll just need to add the headers into this manually but should be easy to do.

MultiVendorMultiImageDATAFEEDMRResults509.xls
	A	B	C	D	E	F	G	H	I	J
1	Internal ID	SKU	Vendor Price	Online Price	United Ostomy & Surgical Supplies	First Choice Medical Supply, LLC	Ford Medical	Independence Medical (ISG)	TwinMed, LLC	Dynarex
2	8841	DYN3552/CS	51.45	84.99	49.38	51.45	48.3	99	99
3	32877	DYN3692/CS	27.06	53.99	27.06					23
Table2

 

[desibouy]

Any way to add Vendor 1, 2, 3, 4 instead of the Vendor name. Ideally the names itself needs to appear below it.