Forum

Inserting a New Row...
 
Notifications
Clear all

Inserting a New Row in PQ

2 Posts
2 Users
0 Reactions
84 Views
(@pseudomvp)
Posts: 6
Active Member
Topic starter
 

Hi,

My first post here.  I have a table with 15 columns in Power Query and want to add a new first row in my table called "Summer", but I only want "Summer to appear in column 1, row 1 and the rest of the row should be empty.  Will need to display the rest of the (15) columns after the new row has been added.  How can I achieve this?

 
Posted : 16/08/2019 12:09 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi and welcome to our forum.

This doesn't sound like a tabular data set, which is what Power Query is designed to do. Are you wanting to add 'Summer' as a type of section header for the rows below? 

Mynda

 
Posted : 16/08/2019 8:35 pm
Share: