Power Query : Add column based on text in cell

F

furqan_yousuf

New Member
Joined
Apr 18, 2021
Messages
5
Office Version
  1. 365
Platform
  1. Windows
power query question.jpg
g
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
Data in pictures cannot be manipulated nor analyzed. To be truthful, I don't have time to reconstruct your problem to provide you with an solution. Please upload your sample data using XL2BB so that we don't have to rebuild your data to solve your problem. Help us to help you by making it easy on us.
 
Upvote 0
Well, you can create something similar, the pictures were just to give you an idea of what I am looking for. I will wait for someone with time, if available on this forum, to respond back and reconstruct something similar. Again the pictures were just to give an idea.
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question Question
Power query - stopping refresh if no data available
Replies
2
Views
192
Kariba
K
J
  • Question Question
Power Query - Keep Folder Collapsed Static
Replies
1
Views
109
Matt Allington
M
I
  • Question Question
Power Query Data types and excel time format issue
Replies
5
Views
368
Anand Sydney
A
C
  • Locked
  • Question Question
Refresh Errors in Power BI Desktop loading queries
Replies
1
Views
108
Fluff
Fluff
M
  • Question Question
Scraping table from site with multiple pages but same url
Replies
1
Views
129
JGordon11
JGordon11

Forum statistics

Threads
1,223,718
Messages
6,174,082
Members
452,542
Latest member
Bricklin

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top