Forum Discussion
Combine Elements together
Looking at the picture, you can see how there are 5 fire stations. I need all of the numbers to be in the same row, so there's only one fire station. How can I do this?
amitchandak I don't really understand what you want me to do. I'm new to Power Bi. I tried making the column but it just gave me errors.
Anonymous
Try following steps in Query Editor:
1. Transpose table
2. Hold shift/ctrl, select the 5 columns with fire stations and merge the 5 columns
3. Transpose table again
4. Replace value (replace the merged cell 5 times fire stations to 1 fire stations)
5. Rename the columns
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.