Forum Discussion
Oliehoek
3 years agoFrequent Visitor
Convert a cell into a column entry in power query
Hi, I am uploading data from daily spreadsheets and the sheet has several tables in them. The first cell of the table is giving me the area the table is referring to and then the data, below this...
- 3 years ago
Hi,
You can obtain this result with the steps of the attached file
Then it is not so clear for me what you need next.
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
- 3 years ago
Thanks!
It is the "Fill > Down" option that I was not aware of.
serpiva64
3 years agoSolution Sage
Hi,
You can obtain this result with the steps of the attached file
Then it is not so clear for me what you need next.
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
Oliehoek
3 years agoFrequent Visitor
Thanks!
It is the "Fill > Down" option that I was not aware of.