Reporting - in same Format for all Sheets

[BRRLL99]

I have following template , Only Amount and File name and value date keeps changing

MASTER CARD EURO	19662 ( Keeps Changing)
ELECTRONIC TRANSFER FROM
TEMPLATE ID	EUR Card
	ACBD Bank
DEBIT	121323
	Settlement Account
CURRENCY	EUR
AMOUNT
VALUE DATE
BANK	ABC BANK
SWIFT CODE	NA
CNN	800A
ACCOUNT NUM	Mastercard
ORGINATOR
Organized by

Input : I have input around 15 rows, for sample 3 are given

Expected Output : Given in Excel file , based on File name new sheet needs to be created in the same format

File-Name	Amount	Date
19662	256788	02-06-2025
18834	10834	03-06-2025
10045	456789	04-06-2025

@binuacs @alexnajm @Qiu 

[Brankl]

Hi BRRLL99, could you please explain what you need help with? It sounds like you have a form where the file name and date value differ across input items. There are different ways to extract that information into the table you provided depending on the input source. For example, if the "amount" field is always in the same cell of an Excel file, you could hard-code a reference to that input location. Or if it is always preceded by the word "Amount," you could use regular expressions to parse the input

[alexnajm]

I am with @Brankl , not sure I understand how you got from your input to your output in this example. Also your file is still virus scanning, so you may need to reupload

[OTrieger · Accepted solution]

@BRRLL99 
You will need to Cross Tab the data. You can put filter before it to get the 3 needed lines or remove the unneeded headers post it to left with these 3 headers.