I currently have a spreadsheet with over 5000 lines of data. Column A contains the duplicate items and column B contains the alternative part numbers I require in separate columns. Vlookup will return the first value, however some items in column A will have 5 alternatives.
Item Alt Alt Alt Alt
70080050TC TC12351
70080050TC PR3134
70080050TC PR4509
70080050TC PR5337
70080050TC PR5646
70080050TC TC12351 PR3134 PR4509 PR5337 PR5646 - This is what I am trying to achieve. Is this possible?
Once again many thanks for your help.
Item Alt Alt Alt Alt
70080050TC TC12351
70080050TC PR3134
70080050TC PR4509
70080050TC PR5337
70080050TC PR5646
70080050TC TC12351 PR3134 PR4509 PR5337 PR5646 - This is what I am trying to achieve. Is this possible?
Once again many thanks for your help.