Certificates!
Member
I am brand new to Power Query and am stuck with what I want to do.
The tables I have imported from Excel has seven Columns:
DATE
NAME
VALUE
BAR
SUBS
PROFESSIONAL
OTHER
In the table there is a date, a name and a value and a matching value in one of the remaining columns.
What I want to do is add another column titled ALLOCATION, and if the matching value is currently in the BAR column, I'd like BAR to be typed into the ALLOCATION column. If it says, SUBS, PROFESSIONAL or OTHER, I'd like that to go into the ALLOCATION column instead.
Then I'd like to remove the four columns.
I'm told Power Query can do this, but apart from adding the new column, I'm stuck.
Any help out there for a compelte novice?
The tables I have imported from Excel has seven Columns:
DATE
NAME
VALUE
BAR
SUBS
PROFESSIONAL
OTHER
In the table there is a date, a name and a value and a matching value in one of the remaining columns.
What I want to do is add another column titled ALLOCATION, and if the matching value is currently in the BAR column, I'd like BAR to be typed into the ALLOCATION column. If it says, SUBS, PROFESSIONAL or OTHER, I'd like that to go into the ALLOCATION column instead.
Then I'd like to remove the four columns.
I'm told Power Query can do this, but apart from adding the new column, I'm stuck.
Any help out there for a compelte novice?