rows - How can I turn part of the Excel data to columns to get a desired output?

Question

For eg - Say I have data in the following format -

Current Format

I would need the data to be formatted in the following format for ease of use -

Required Format

Of course the data contains a lot more records - I'm looking for an easy way to transpose data in this way for large sets of data.

Any help will be appreciated :)

Answer 1

What you want to do is called:

Unpivot:

1. Select the data and on the Insert menu choose Table
2. On the Data menu click From Table/Range
3. The query window will open. Choose the columns you need to extract. With your data the columns to highlight are "Type" and "Number of Cases"
4. On the Tranform menu choose Unpivot Columns
5. If the data looks right now, close the Query Editor (accepting changes).

Examples here: Unpivot Excel Data