Share via

Transpose and Stack data

Anonymous
2023-12-07T08:05:10+00:00

I have this huge dataset that i need to transpose and stack up. Any help will be very much appreciated. This is how the data looks like:

Sales Data

Country Company Number

A X1 12

                         X2                        13  
                         X3                        14

B X1 13

                        X2                          13

                        X3                           14

I want the information to be like this

Country X1 X2 X3

A 12 13 14

B 13 13 14

Please help guys

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 102K Reputation points Volunteer Moderator
    2023-12-08T00:06:01+00:00

    Hi,

    Fill the blanks in column A with A's and B's. Then create a Pivot Table. You may fill in the blanks by first highlighting the blanks (Ctrl+G > Special > Blanks > OK). Then press = and the up arrow key. Confirm with Ctrl+Enter.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-12-07T08:30:57+00:00

    You may try Power Query

    1. Data> get data from range.

    1. Select column A, Fill down

    1. Select Column B, Povit Column, Value column choose number.

    1. Result:

    Was this answer helpful?

    0 comments