Need to Create Unique Column Based on Row Values
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi .@IraWatt
Thank you for replying. Yes, but the data under each product (sku_name) should only be the cur_price,
Like this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No worries @Fescobar :D glad it worked for you !
