Need to Create Unique Column Based on Row Values

[Fescobar]

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

[IraWatt]

Hey @Fescobar,

Is this what you were looking for?

[Fescobar]

Hi .@IraWatt

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

Like this.

[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.he table below.

[IraWatt · Accepted solution]

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

[Fescobar]

@IraWatt 

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

Thank you!!

Fausto

[IraWatt]

No worries @Fescobar :D glad it worked for you !