Summarize Data into Pie Chart but from Different Columns

[ahasanahp]

Hi,

I need to summarize data into a pie chart with the following table

ID	First Transport Qty	First Transport	Second Transport Qty	Second Transport
1	1	TRUCK	7	CAR
2	3	MOTORCYCLE
3	1	CAR	2	TRUCK
4	5	BICYCLE	3	MOTORCYCLE
5	2	TRUCK	2	TRUCK

I need to have a Pie Chart that displays the total split % or volume such as :

TRUCK - 7

CAR - 8

BICYCLE - 5

MOTORCYCLE - 6

The problem is that I have 2000 rows and can only pull out the "First Transport" column only, I can't include the "Second Transport" column.

How can I create a pie chart that shows all of the data labels with their combined values?

Thanks

[whitch]

Imagine how much easier this would be if your data was structured like this:

Qty	Transport	Type
1	TRUCK	First
3	MOTORCYCLE	First
1	CAR	First
5	BICYCLE	First
2	TRUCK	First
7	CAR	Second
0	null	Second
2	TRUCK	Second
3	MOTORCYCLE	Second
2	TRUCK	Second

Can you make it like this in Power Query?  You'll probably want to duplicate your current table, have one copy just for firsts, the other for seconds, then apppend together to get a result like the above (you can disable data-load for the intermediary tables).