Organizing Dataset in Different Orientation.

Hello,

I am trying to work large amounts of data and organize it in a different way.

I have attached a Excel Book with the pattern I need the data organized as.

The excel book has two sheets. What I am trying to do cannot be done manually because my database has around 700 clothing items.

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

Thanks for the change.

Would you actually have percent and/or decimals in your string?

With your data starting in A1 down and your answer starting in B1, this is partially working...
=TRIM(MID(SUBSTITUTE($A1,".",REPT(" ",LEN($A1))),LEN($A1)*(COLUMN()-2)+1,LEN($A1)))