IRSHATH7860
New Member
I need to merge the description column when there is no date or amount in a4 and c4. How can it be done using Power Query in excel and remove the + sign and keep - sign in front of no.
Merging in Power Query Function
- Thread starter IRSHATH7860
- Start date
Chihiro
Excel Ninja
I'd recommend manually creating sample desired output.
Without it... we are guessing as to exact format you need things in.
General steps.
1. +/- should be handled just by converting it to type number.
2. Set Date column to date type, description to text type.
3. Add index column.
4. Add custom column.
5. Select the custom column added above and "fill down"
6. Remove index column.
7. Group by Custom column above, and "All Rows" i.e. no aggregation. (temp)
8. Add custom column
9. Remove Custom and expand temp excluding [Description] & [Custom]
10. Filter out where {Balance] = null
11. Reorder columns as needed.
Without it... we are guessing as to exact format you need things in.
General steps.
1. +/- should be handled just by converting it to type number.
2. Set Date column to date type, description to text type.
3. Add index column.
4. Add custom column.
Code:
= if [Date] <> null or [Index] = 0 then [Index] else null6. Remove index column.
7. Group by Custom column above, and "All Rows" i.e. no aggregation. (temp)
8. Add custom column
Code:
= Text.Combine([temp][Description]," ")10. Filter out where {Balance] = null
11. Reorder columns as needed.