Transpose rows to column and join table

[Agoyman]

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.

[Excel Fox]

Welcome to ExcelFox.

Not a VBA solution, but a simple directional example which you can expand. If you need more handholding, please revert.

Have used a simple pivot and an array formula, but fairly simple, if this is not a repetitive process which requires automation.