I have try to use pivot table to consolidate the data of the data below.
However, it is to complicate and I've lost. Any one could help me?

soure data :
"Doc:",":","1234"
"Cost","',"","Amount"
"Nil"
"Doc",":","","1235"
"Cost","","","","Amount"
"CC","","","","230.50"
"DD","","","","135"
"EE"
"Total","","","","HKD12/pc"
"Doc:",":","","1236"
"Cost","","","","Amount"
"CC","","","","220"
"EE","","","","145"
"Total","","","","USD14/pc"

Expect result
Doc CC DD EE Total
1234
1235 230.50 135 HKD12/pc
1236 220 145 USD14/pc

I wish someone could help me out. Thanks!