Hi @Casey Butcher? ?,
Thank you for sharing these instructions and this information! You can accomplish this by using the “Merge columns” transformation. Select the “Cost Price”, “Selling Price”, and “Total Sales” columns to merge:Name the new column the car make, “Ford” for example. Repeat this step with the other car makes. You can delete the old columns once merging columns is done.
Next, you can use the “Unpivot” transformation to convert the “Ford”, “Toyota”, and "Hyundai” columns into rows of keys (“Make”) and values (“Cost Price”, “Selling Price”, and “Total Sales”) while keeping the group size to 1:
Your screen should now have a “key and “value” column. To split the “Cost Price”, “Selling Price”, and “Total Sales” values in “value” column, you can use the “Split between delimiters” transformation. Select the “value” column. Under option, select “By delimiter”. In the “Delimiter” field, type in the comma (including the quotation marks). Lastly, select the number of commas you want to split in the “Number of splits” field. Your screen should look like this after composing your step:
Once your values have been split, you can use the “Rename columns” transformation to rename the “key” (“Make”), “value1” (“Cost Price”), “value2” (“Selling Price”), and “value3” (“Total Sales”) columns:
Let me know if this helps! If it does, please mark the answer "Best answer" so that other users know that your question has been resolved. 🙂
