Need to Create Unique Column Based on Row Values

Hello Community,

I hope that everyone is doing well.

I have tried several variations of workflows that came to mind using the Cross Tab, Multi Row Formula, and even tried to trick the app into doing what I needed in "reverse" Transpose (I know...HUGE reach on this one).

I need to be able to create one column for each item name on column A (sku_name). The attached spreadsheet has my current format in the "Current" tab and what I need the result to be in the "Required" tab.

Any assistance on this will be greatly appreciated.

Thank you,

Fausto

Retailer.xlsx

Datasets

Common Use Cases

Transformation

Expression

Accepted answers

IraWatt

Ah nice ! @Fescobar in that case all you need is cross tab

Example 2.yxmd

All comments

IraWatt

Hey @Fescobar,

Is this what you were looking for?

Workflow 2505.yxmd

Fescobar

Hi .@IraWatt

Thank you for replying. Yes, but the data under each product (sku_name) should only be the cur_price,

Like this. Retailer File Requirement.jpg

IraWatt

No worries @Fescobar, the price is there. Do you want other columns headers other then the SKU? What data do you want under each of the SKU columns?

Fescobar

Thanks again .@IraWatt

The only thing that should be under the product names i.e. Grey Goose Vodka (1.75L), Grand Marnier (750ml) should be the value for cur_price. Everything else should be its own header. Like this screenshot. Retailer File Requirement2.jpg he table below.

IraWatt

Ah nice ! @Fescobar in that case all you need is cross tab

Example 2.yxmd

Fescobar

@IraWatt

This is so simple, that its SMOKING HOT!!!

Thank you!!

Fausto

IraWatt

No worries @Fescobar glad it worked for you !

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703