Help to include repetitive word on column

[xin_er]

Hi all,

I have a set of figures churn from pivot table. its basically on stock takes.
After the pivot process, I have also included a column B namely "Color".

I would like to shift the subset of column A into column B.
I need repeat this process without doing manually.

You may get a better picture after looking at the spreadsheet.



Anyways to do it?

Its pretty urgent. Any help will be appreciated.

Thanks!

 

[Rick Rothstein]

I am not entirely sure what you are after here. The problem seems to be you expecting us to understand your business model and how it works from a small, partial snippet of information... personally, I can think of three different ways to expand your data given what you showed us, so I have no idea how to respond to you.... and I am guessing from your lack of response, I am not the only one with this reaction. Help us to help you... show us an example of your data immediately before whatever macro we give you runs and then show us how you want that same data to look after the macro runs... seeing the full picture of what is being manipulated and how should give us enough information to create a macro for you.

 

[xin_er]

I am not entirely sure what you are after here. The problem seems to be you expecting us to understand your business model and how it works from a small, partial snippet of information... personally, I can think of three different ways to expand your data given what you showed us, so I have no idea how to respond to you.... and I am guessing from your lack of response, I am not the only one with this reaction. Help us to help you... show us an example of your data immediately before whatever macro we give you runs and then show us how you want that same data to look after the macro runs... seeing the full picture of what is being manipulated and how should give us enough information to create a macro for you.

Pardon me. The intend was to upload the source file for download, however, being new to the forum and in the nick of time, I thought a snippet would suffice.

<a href="http://www.filefactory.com/file/49yu5ek4q8nj/A%2B%20Class%20SKU%20distribution%20by%20style%20and%20color.xlsx"> Excel File </a>

My apology.

 

[Rick Rothstein]

Pardon me. The intend was to upload the source file for download, however, being new to the forum and in the nick of time, I thought a snippet would suffice.

Excel File

I have been having trouble with my computer (needs to have Windows reinstalled, but I have been putting it off) and one problem is trying to download things from websites.... I am not able to download your file from that website. But I don't think we need your original file to help you. If you could include two pictures (just like you did for the one picture in your original message) in a response, that would be good enough. The first picture should be of the data (the number of items that you posted originally would be fine) just before you want it manipulated by a macro and the second picture would be what that same data should look like after the macro manipulates it. I am pretty sure that before-and-after presentation should be enough for us to understand what you want.