Transforming Data

[zwyne]

Hi Experts,

Quick question, I normally received data on my email everyday and is on this format like below:

Account number: 122225

Date: 09/01/2018

Method of transaction: XXX Credit

Amount : 233610,97

Account number: 554555

Date: 02/11/2017

Method of transaction: XXX Credit

Amount: 155403,09

Account number: 678919

Date: 16/10/2017

Method of transaction: XXX Credit

Amount: 151698,36

Expected output on my Qlikview application is

Account number	Date	Method of transaction	Amount
122225	09/01/2018	XXX Credit	33610,97
554555	02/11/2017	XXX Credit	155403,09
678919	16/10/2017	XXX Credit	151698,36

Your assistance will be highly appreciated

[Anil_Babu_Samineni]

From Email you want to pull data?