reporting prior fields

Question

Need formula help.&nbsp; my pdf is all the information to the left of desired column.&nbsp; I want the type of payment repeated in a column.&nbsp; Desired column is what I'm looking for.&nbsp; Appreciate your help!&nbsp;&nbsp;&nbsp;&nbsp;Site:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Uptown - YWCA Minneapolis&nbsp;&nbsp;Payment Type:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cash&nbsp;&nbsp;DateInvoice #LocationOperatorMember #Member NameAmount&nbsp;&nbsp;&nbsp;Desired column08/21/223428159Membership ServicesAnieka G.UT20044093Alice Lee&nbsp;$8.00&nbsp;&nbsp;Cash08/21/223428162Membership ServicesAnieka G.UT20044247JR Reece&nbsp;$20.01&nbsp;&nbsp;CashPayment Type:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CC AMEX&nbsp;&nbsp;DateInvoice #LocationOperatorMember #Member NameAmount&nbsp;&nbsp;&nbsp;&nbsp;08/21/223428158Membership ServicesAnieka G.UT20037894Nicole Brilakis&nbsp;$128.00&nbsp;&nbsp;CC AMEX08/24/223428184Membership ServicesJulleen R.UT20044247JR Reece&nbsp;$5.40&nbsp;&nbsp;CC AMEX08/26/223428203Membership ServicesJulleen R.UT20043016Jessica Lourey&nbsp;$259.26&nbsp;&nbsp;CC AMEX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total Payment:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $392.66&nbsp;&nbsp;CC AMEX

anonymous · Accepted Answer

HI&nbsp;Anonymous,
Do you mean these type strings are mixed and stored with date values in the same column?If that is the case, I'd like to suggest you add a custom column to check and extract value if the current row existed with 'Payment Type' strings, then you can use the 'fill down' feature to fill the following rows to remark correspond records.
Text.Contains - PowerQuery M | Microsoft Docs
Fill values in a column - Power Query | Microsoft Docs
Regards,
Xiaoxin Sheng

Forum Discussion

reporting prior fields

1 Reply

Related content

Owner/Contact Field on reports

Remaining Balance Depends on Prior Month

Paginated Report - Field Parameter

Field Parameter Question

Field Parameters in Report Server

Site: Uptown - YWCA Minneapolis
Payment Type: Cash
Date	Invoice #	Location	Operator	Member #	Member Name	Amount			Desired column
08/21/22	3428159	Membership Services	Anieka G.	UT20044093	Alice Lee		$8.00		Cash
08/21/22	3428162	Membership Services	Anieka G.	UT20044247	JR Reece		$20.01		Cash
Payment Type: CC AMEX
Date	Invoice #	Location	Operator	Member #	Member Name	Amount
08/21/22	3428158	Membership Services	Anieka G.	UT20037894	Nicole Brilakis		$128.00		CC AMEX
08/24/22	3428184	Membership Services	Julleen R.	UT20044247	JR Reece		$5.40		CC AMEX
08/26/22	3428203	Membership Services	Julleen R.	UT20043016	Jessica Lourey		$259.26		CC AMEX
					Total Payment: $392.66			CC AMEX