Formatting Multi-Sku Items

Hi Martin,

Thank you for the forum question.

Sorry about the late answer.

Please in the future do not address the questions to me. I like to answer your questions, but when it is addressed to me, the question will be forwarded to me and not to an available trainer. It means that if I am not at work or onsite, it can take much longer before you receive an answer.

Yes you must have an issue with the data. It can be errors, spaces, or unprintable characters in your data source. Check the column quality in the QUERY EDITOR (the VIEW tab). You may spot something.

I have created a data set similar to what I can understand you have in your data set. I have no problems getting a record for each SKU number by SPLIT COLUMN BY DELIMITER. Instead of UNPIVOT COLUMNS I in the ADVANCED options in the SPLIT COLUMN BY DELIMITER dialog box selected ROWS instead of COLUMNS. I do not know if you have spaces on both sides of the delimiter x. If you have you will have to use the TRIM tool to remove them before you change the data type to number.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector