Forum Discussion
Create a column based on data from other columns
Community ChampionDo you always want to carry that to the next line or only in specific circumstances?
Depends on the circumstances. There may also be several lines below. The subaccount I want to carry must have the same number as the column Asiento.
Thank you very much and best regards.
- MarcelBeug
Please be more specific.
Do you always have pairs of 2 rows with the same number? If there are more rows with the same number, which one(s) must be carried over to which other row(s)? If multiple numbers must be carried over to the same row, do you want to have them comma separated?
In which case do you want the number from one row to be carried over to the other row?
In your examples, the number from the second row is carried over to the first row, but the number from the first row is not carried over to the second row.
Hello,
What I want is to take me from the SUBCUENTA column a certain account, for example, 211200, to the CONTRA CTA column. What they have in common is the number of the ASIENTO column. A ASIENTO number can be composed of different rows. In the following example, the account is three rows below, but may be in the bottom row or two lower row, ...
ASIENTO SUBCUENTA DEBE HABER CONTRA CTA 34 211000 100 0 211200 34 600000 250 0 34 572000 0 250 34 211200 0 100
I only want to carry the number of the subaccount marked red in the column against cta. The subaccount numbers you carry belong to a certain group.Thank you very much and best regards.
