Hi there, i have some table like this:

id | Date | key_info | value_info
2 | 13 May | amount | 1009
2 | 13 May | currency | USD
2 | 13 May | Level | Level 5
3 | 14 May | amount | 2017
3 | 14 May | currency | CAD

I need VBA code to automaticaly make new table like this:

id | Date | amount | currrency | level | status
2 | 13 May | 1009 | USD | Level 5 | Pending
3 | 14 May | 2017 | CAD | | Approved

Anyone cnn help? or give me example for VBA that do something that. Thanks.