How to add an column and change the column name?

[phoebe_90]

Transfer sheet 1 to sheet2

sheet1

Account	Amount in local currency
24508272	-29.55
69011530	29.55
24508272	-6.68
68121000	6.68

if Amount in local currency>0,Debit/Credit Indicator*="s"

if Amount in local currency<0,Debit/Credit Indicator*="H"

sheet2

General Ledger Account	Debit/Credit Indicator*	Amount in Document Currency*
24508272	H	29.55
69011530	S	29.55
24508272	H	6.68
68121000	S	6.68

[FinnCharlton · Accepted solution]

Hi @phoebe_90 , this workflow will do that for you. Hope it helps!