In power query for excel I can get as far as columns A-E. What I would like to achieve within power query (maybe power pivot?) is to have a new column added 'F' which is the data of the last populated column from A-E.
Sample Data attached
In power query for excel I can get as far as columns A-E. What I would like to achieve within power query (maybe power pivot?) is to have a new column added 'F' which is the data of the last populated column from A-E.
Sample Data attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks