Transpose with format

[stan255]

Hi,
I'm trying to transpose this format of Excel file.
transpose.png

Quick rundown
Each row consists of sales from each product type (Shoes and Clothes) with total sales from the company in column C.

What we're trying to accomplish
Move all the products (Column D) and product sales (Column E) into one line.
Example shown in the table below.

For example, Nike Shoes (column D) and its sales (column E) and Nike Clothes (column F) and its sales (column G)

Example #2 is trickier, Adidas didn't have any shoe sales so we leave the shoe column blank (column D and E).

I have attached an example of this Excel sheet.

Any help or ideas would be greatly appreciated!

[sysss]

Hello,

I think, it is too short data example. Do you really have only two products or there are more (i believe so). Will column D always be [company name] space [product type]? You don't have a list of possible products? So you may end up with many columns...?

Thanks
sysss

[stan255]

We have around 7 products and yes you're right Column D will always be shoes and Column E will always be clothes.

But not all companies will have sales for each product. In this case, Adidas doesn't have sales for shoes.

[jindon]

Try

Please Login or Register  to view this content.

[stan255]

It worked perfectly! I would have +rep but I have +rep too many times to you (according to the website)

[jindon]

Did you?

I can't find any from you.

Anyway,
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[stan255]

"You must spread some Reputation around before giving it to jindon again."

[jindon]

OK, don't worry about it.

Your good feed back is better than rep.