Transpose Data from column to Row

[hardeep.kanwar]

Dear Experts

I need to transpose the data from column to Row (Below is the example of my data)

Format is not always same some have 7 rows and some have 8 rows, After every data, there is Blank row,for me main problem his Amount (Column B), I need to insert the new Column After EFT INCOMING and put the amount

Can you please help on this

Data in sheet 1

EFT INCOMING	4,312.00
SAA230887163 NEFT IN UTR
CITIN16713406945 FROM MS
SHEKHAR VEHICLES
SAA230887163TXN REF NO
URGENTMS SHEKHAR VEHICLES
TRN REF NO:D01ZOAC163331S0R
EFT INCOMING	4,312.00
KKBKH16333640302 NEFT IN
UTR CITIN16713400139
FROM SATYA SERVICES
KKBKH16333640302TXN REF
NO Payment
TRN REF NO:D01ZOAC163331S1s
EFT INCOMING	8,625.00
AXISP16333234589 NEFT IN
UTR CITIN16713255608
FROM K L GUPTA AND CO
AUTOMOBI
AXISP16333234589TXN REF
NO 01281116364601
TRN REF NO:D01ZOAC163330sKC

<tbody>
</tbody>

Expected result In Sheet 2

<!-- Please do not remove this header -->

EFT INCOMING	4,312.00	AXISP16333234589 NEFT IN	UTR CITIN16713255608	FROM K L GUPTA AND CO	AUTOMOBI	AXISP16333234589TXN REF	NO 01281116364601	TRN REF NO:D01ZOAC163330sKC
EFT INCOMING	4,312.00	SAA230887163 NEFT IN UTR	CITIN16713406945 FROM MS	SHEKHAR VEHICLES	SAA230887163TXN REF NO	URGENTMS SHEKHAR VEHICLES	TRN REF NO:D01ZOAC163331S0R
EFT INCOMING	8,625.00	KKBKH16333640302 NEFT IN	UTR CITIN16713400139	FROM SATYA SERVICES	KKBKH16333640302TXN REF	NO Payment	TRN REF NO:D01ZOAC163331S1s

<tbody>
</tbody>

 

[hardeep.kanwar]

That Better and Thanks again for your support