I have following template , Only Amount and File name and value date keeps changing MASTER CARD EURO19662 ( Keeps Changing)ELECTRONIC TRANSFER FROM TEMPLATE IDEUR Card ACBD BankDEBIT121323 Settlement AccountCURRENCYEUR AMOUNT VALUE DATE BANKABC BANK SWIFT CODENA CNN800A ACCOUNT NUMMastercard 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-NameAmountDate1966225678802-06-2025188341083403-06-20251004545678904-06-2025 @binu_acs @alexnajm @Qiu Reporting - Expected Output.xlsx

Reporting - in same Format for all Sheets

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

@binu_acs @alexnajm @Qiu

Reporting - Expected Output.xlsx

Reporting

Accepted answers

OTrieger

@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.

All comments

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

@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.

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167