Transpose Data to Create new table

[zifu886]

Hi Expert,

Im learning excel while I work on parsing large amount data. Need your help me to create a new table from old table as listed below. Your help is highly appreciated. Thank you once again in advance for your great help,

Sincerely
Zi

Source Table
Order_Aging	Company	Order Date	Order	Order Due Date	Amount
1 - 30	All-Good	12/11/2018	1234	12/11/2018	2400
31 - 60	All-Good	11/26/2018	1200	11/26/2018	7200
Current	UC-Tower	12/21/2018	#40	12/31/2018	1100
1 - 30	UC-Tower	12/7/2018	135		200
- 90	UC-Tower	12/7/2018	#38	12/17/2018	100
> 90	UC-Tower	12/21/2018	136		15000
current	Hello.com	12/17/2018	#7657	1/16/2019	90
current	Hello.com	12/31/2018	72	1/10/2019	100
New Table
Order_Aging	Company	Order Date	Order	Order Due Date	Current	1 - 30	31 - 60	61 - 90	> 90	Amount
1 - 30	All-Good	12/11/2018	1234	12/11/2018		2400				2400
31 - 60	All-Good	11/26/2018	1200	11/26/2018			2400			2400
current	UC-Tower	12/21/2018	#40	12/31/2018	1100					1100
1 - 30	UC-Tower	12/7/2018	135			200				200
61 - 90	UC-Tower	12/7/2018	#38	12/17/2018				100		100
> 90	UC-Tower	12/21/2018	136						15000	15000
current	Hello.com	12/17/2018	#7657	1/16/2019	90					90
current	Hello.com	12/31/2018	72	1/10/2019	100					100

<tbody>
</tbody>

 

[zifu886]

Thanks Sandy666 once again. Have a nice weekend

Zi