Power Query

[jaymack]

I have a power query...query. how can I copy data from a cell in power query into a column. I.e column name Tuesday into Column 2 all the way down?

Hope that makes sense

 

[RoryA]

Not really. You can't really return just one cell from a query - you return the whole thing. Can you elaborate on exactly what you have in PQ and what you are trying to achieve? (I can't really see any point to putting the same value in every cell in a column)

 

[Alex Blakenburg]

Try:
1)
• Give the Cell a Range Name eg DayOfWeek.
• Load it to Power Query > Data from Range
• In PQ for that Query removed the Promote Header & Changed Type steps
• Load as connection only
2) In the orginal Query
• Add Custom Column
• Enter "= DayOfWeek" (without the quotes)
• Expand the column and give it a column heading

 

[jaymack]

Try:
1)
• Give the Cell a Range Name eg DayOfWeek.
• Load it to Power Query > Data from Range
• In PQ for that Query removed the Promote Header & Changed Type steps
• Load as connection only
2) In the orginal Query
• Add Custom Column
• Enter "= DayOfWeek" (without the quotes)
• Expand the column and give it a column heading

Amazing, that did the trick. Thanking you

 

[Alex Blakenburg]

You're welcome. Glad we could help.