1 ACCEPTED SOLUTION
@Anonymous
>> Go to Power Query Editor >> Select Column that you want Group by >> After selecting column >> In home tab you see group by icon >> click on >> grouping as per your requirement.
THANK YOU!!
| Price | Qty | Purchase price | |
| Material 1 | $ (13,000) | $ 5,000 | $ (8,000) |
| Material 2 | 5,000 | 2420 | 7420 |
Pretty much i have 3 more variants of this similar formula Horizontally. Vertically there are more mateials . I would like to Group these three columns into one field so that when i splicer that field these values come up and so on and so forth for the other variations of this formula that appear later in the data sheet.
@Anonymous
>> Go to Power Query Editor >> Select Column that you want Group by >> After selecting column >> In home tab you see group by icon >> click on >> grouping as per your requirement.
THANK YOU!!
Can you post some sample data with expected output and what you intend to do with the value?
